Thread: copy data from a hidden column to another sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chrisso Chrisso is offline
external usenet poster
  
Posts: 110
Default copy data from a hidden column to another sheet
Try:

My_Range.Worksheet.Columns(5).Hidden = False

to reveal and:

My_Range.Worksheet.Columns(5).Hidden = True

to hdie again.

Chrisso



On 16 Sep, 15:44, Jock wrote:
Hi,
I have used code from Ron De Bruin which will copy entire rows that meet a
specific criteria to another worksheet.
This works really well unless there are hidden columns in the source sheet.
Reply With QuoteReply With Quote