Offset Glitch
 

From an active cell, how can I select that cell and the two to its right?

Thanks,
Arturo

Offset Glitch
 

Range(Activecell,Activecell.Offset(0,2)).Select

"Arturo" wrote:

From an active cell, how can I select that cell and the two to its right?

Thanks,
Arturo

Offset Glitch
 

Arturo,

Try something like

ActiveCell.Resize(,3).Select


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Arturo" wrote in message
...
From an active cell, how can I select that cell and the two to
its right?

Thanks,
Arturo