Thread: Macro - select
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
puiuluipui puiuluipui is offline
external usenet poster
 
Posts: 468
Default Macro - select

It's perfect!
Thanks!

"Jacob Skaria" a scris:

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!!!