storing activecell.row value for later use?

Please Login or Register  to view this content.

With the above, once the selection changes on the second line of code the 'a' active row location number will be different as the current selected cell has changed

Is there a way to store the row number in the first 'ActiveCell.Row' line of code for reference in the 'Offset(a,0).Select

Many thanks

It's not very clear what you're trying to do, but the line

Please Login or Register  to view this content.

will have already stored the row number of the original active cell. That's assuming that this is the start of your macro.
It may help to post more of your macro code up to help with context.
As it is, your code is using a row number to create an offset for the column being selected. I only point that out as your code differs from the line in your question where you have the variable 'a' offseting the row not the column.
Syntax is Offset([row],[column])

Hi, hb316,

maybe try it like this

Please Login or Register  to view this content.

Please Login or Register  to view this content.

won´t take you to the right (Columns) but down (Rows). So you should not look for the row but rather the column and add 15 to that.

Please Login or Register  to view this content.

Ciao,
Holger