Thread: Change a specific code to generic in VB macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sue Sue is offline
external usenet poster
  
Posts: 285
Default Change a specific code to generic in VB macro
I have the following:

Selection.AutoFill Destination:=Range("BE2:BE567"), Type:=xlFillDefault
Range("BE2:BE567").Select

I would like to change the code to include all possible used cells to fill.
How do I do this?

--
Sue
Reply With QuoteReply With Quote