get column name
 

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

get column name
 

msgbox "The value in " & range("a1").offset(x,y).address(rowabsolute:=false ,
columnabsolute:=false) & " is wrong"


"Agostino" wrote:

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