Run-Time error '91': Object variable or With block variable not set

[bs04do]

Hello,

I am getting the error "Run-Time error '91': Object variable or With block variable not set", which stops at 'visible = c.Address' in the code and I'm not sure why because I have defined both "c" and "visible". Any help is appreciated!

Please Login or Register  to view this content.

Thanks,
Brad

[AB33]

Cell address can not be a range

Dim visible As string

[bs04do]

Thank you! I literally just tried that as you replied and got it to work.

[bs04do]

Another problem...now on the 'Range(c).Select' portion I get a run-time error '1004': Method 'Range' of object '_Global' failed...

[AB33]

You do not need to select, just delete that line, but I suspect the code will error on this line

'Range(c).Select

Please Login or Register  to view this content.