Hi, all. I'm very new to VBA and Macros so apologies in advance for this simple question.
I need to highlight an entire column to the right of the Active Cell. How far to the right is defined by a number in A2. I had considered using the following:
whereas x = a number contained in A2.![]()
Range("A1").Offset(0,x).Select ActiveCell.EntireColumn.Select
What do I substitute here for the x, or is there another way?
Many thanks in advance.
Darren
Bookmarks