Thread: Macro - select
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Macro - select
Range("C10:K90").SpecialCells(xlCellTypeConstants, _
xlNumbers + xlTextValues).Select

If you want to select xlErrors and xlLogical add those to xlNumbers +
xlTextValues

--
Jacob (MVP - Excel)


"puiuluipui" wrote:

Hi, i need an macro to select all filled cells in range C10:K90.
Can this be done?
Thanks!!!
Reply With QuoteReply With Quote