get column name

  • Thread starter Thread starter Agostino
  • Start date Start date
A

Agostino

I iterate throught the cells of a Range using Offset method.
When I encounter a specific value, I would like to show a message box saying
'The value in B5 is wrong".
How can i get the 'string reference', B5 in this case, of a cell?

Thanks in advance
Agostino
 
msgbox "The value in " & range("a1").offset(x,y).address(rowabsolute:=false,
columnabsolute:=false) & " is wrong"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

passing cell address to sub - write that cell 2
Write to intersect of a row and column 7
Address of Selection Prior to Clicking on a Cell 1
Need help with listbox 6
add new chart in 2007 7
Named Range maker code 9
Combobox Rowsource 2
A little help needed please... 7

Back
Top