vba query simple variable

[mgkmn]

How do I assign the value of a cell to a variable?

[rylo]

Hi

Could be

Please Login or Register  to view this content.

rylo

[Trebor76]

Hi there,

Try:

Please Login or Register  to view this content.

Note that this will return the relative reference of the active cell (i.e. A1). Simply change the row and column arguments (False, False) to True to return absolute row and column references to suit.

HTH

Robert