View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Beto[_3_] Beto[_3_] is offline
external usenet poster
 
Posts: 140
Default Range Selection shouldn't be this difficult!

SFWhite wrote:
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?


Sub Fill25CellsDown()
Selection.Resize(25, 1).Select
Selection.FillDown
End Sub

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.