View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SFWhite SFWhite is offline
external usenet poster
 
Posts: 1
Default Range Selection shouldn't be this difficult!

I want to simply select this cell and the next 25 cells for a quick
fill down.

Range("A2:A25").Select
Selection.FillDown

The above works fine.

BUT -

I want to do this from any cell I am sitting on: (For example)

Range("RC[1]:R[24]C[1]").Select
Selection.FillDown

I cannot make this work with any combination of anything I have tried
or found on this ng.

Anyone have a suggestion?

Thanks in advance.