View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How write to hidden columns with VBA?

Cells(1,10).Value = 1000
puts 1000 in Cell J1 whether the column is hidden or not

--
Regards,
Tom Ogilvy

"Michel" wrote in message
om...
Is there a way to write to hidden columns from vba without unhiding them

first?