View Single Post
 
Old 03-29-2016, 11:01 PM
Rod_Bowyer Rod_Bowyer is offline Windows 10 Office 2007
Novice
 
Join Date: Mar 2016
Posts: 12
Rod_Bowyer is on a distinguished road
Default Would like a Macro to Select a Variable Area

I hope that it is ok to post these requests.

I also hope that this is an easy one - but for a novice like me it is difficult.

I have data in columns G to R starting at cell G19. The number of rows varies each time I bring in a new record. I would like a macro which would highlight the area from G19 through to R "whatever number" ("whatever number" will vary each time I run the macro).

When I record a macro I go from G19 end down and then select right until column R. Unfortunately the macro "anchors" itself according to how many records there are in Column G at the time I write the macro. The next time that I run the macro with more records in it it only highlights the previous area.

I hope that I have explained this ok

Many thanks - Rod
Reply With Quote