Selecting an entire column using a reference defined in another cell

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:

Please Login or Register  to view this content.

whereas x = a number contained in A2.

What do I substitute here for the x, or is there another way?

Many thanks in advance.

Darren

Hi, Darren,

maybe start with something like

Please Login or Register  to view this content.

but I´d like to express that most of the time it´s unnecessary to Select or Activate as whatever action is wanted to take place in almost all cases may be done without these commands.

Ciao,
Holger