Hi,
I would like to create a macro that selects a certain area in a dynamic range. FirstRow and LastRow are variables.
I wrote:
....and get an error message.range("H" & FirstRow: H" & LastRow).select
However,
....works fine.range("H1: H" & LastRow).select
What am i doing wrong?
Any input is much appreciated!
Bookmarks