View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] robert.hatcher@l-3com.com is offline
external usenet poster
 
Posts: 55
Default Selection.Resize error

I want to starting at a single cell selection, offset two columns and
expand the selection two two cells.
So far I am using:

ActiveCell.Offset(0, 2).Select

Selection.Resize(0, 2).Select

However, I get the runtime error: Application-defined or
object-defined error

Probably just another case of me using something in the wrong place but
I cant see what else to do.

Any help will be appreciated.

Robert