madkinson
Board Regular
- Joined
- Dec 17, 2004
- Messages
- 113
- Office Version
- 365
- Platform
- Windows
I need to select a range, but it is in the middle of a column. For example, I have a macro that will take a formula in cell F2 and copy it into a range from F3 to the end of the column. I already have defined a variable called LastRow, however I cannot seem to get the syntax right for the Range.Select statement. What I tried was:
Range(F3,"F"&LastRow).Select
I appreciate your patience with this newbie question.
Range(F3,"F"&LastRow).Select
I appreciate your patience with this newbie question.