Hide a Column in Excel

dianecandice

Hi,

if setting a value in excel is written as:

WorkSheet.Range('A1').Value := 'test';

what is the syntax for hiding the column A?

Thanks,
diane

SHardy

Try:

WorkSheet.Columns('A').Hidden := True;

dianecandice

hi,

thanks for the reply,

i tried it but i get an error. seems like it does not accept any parameter for Columns()

diane

SHardy

OK, try this then:

WorkSheet.Range('A1').EntireColumn.Hidden := TRUE;

dianecandice

hi SHardy,

it worked Thanks a lot

Regards,
Diane