Hide cell contents using VBA

[wunderbarre]

Hi experts,


I am trying to write a vba code to hide contents of few cells in the worksheet.

I have the cell address that needs the modification in another cell.

The code should take the cell number and hide the contents of the text that is being displayed in another cell.

For example:

C2=D98

D98= Marketing

I would like to see the Marketing text to be hidden/white text.

Regards,
Wunder

[nigelbloomy]

Try this:

Please Login or Register  to view this content.

[wunderbarre]

Try this:

Please Login or Register  to view this content.

Hmm

Thanks Nigel.

But it has to reference the cell C2 in the sheet first. d98 is not static and keeps changing depending on the user.

[Mumps1]

Maybe:

Please Login or Register  to view this content.

[nigelbloomy]

Sorry. I didn't understand the first time. This should work then.

Please Login or Register  to view this content.

[wunderbarre]

Sorry. I didn't understand the first time. This should work then.

Please Login or Register  to view this content.

Hi Nigel,

Thanks again.

I get a run time error '1004'

When I use the above code.

It points to

Please Login or Register  to view this content.

Does range take stValue?

[nigelbloomy]

It will if stValue is a string. Try this:

Please Login or Register  to view this content.

[wunderbarre]

Hmm changed it and it still shows the error.

[nigelbloomy]

It works for the example you posted. What is the actual formula in C2? This code can only handle a formula like =D98. The code looks at the formula in C2 and takes off the = sign and then gives that to the range to turn white. If the formula has more in it like =if(D98="Marketing,"Marketing,""), then we need to use a different method to find the cell reference in there.

[wunderbarre]

It works for the example you posted. What is the actual formula in C2? This code can only handle a formula like =D98. The code looks at the formula in C2 and takes off the = sign and then gives that to the range to turn white. If the formula has more in it like =if(D98="Marketing,"Marketing,""), then we need to use a different method to find the cell reference in there.

Hi Nigel,

Thanks.

The cell C2 just has D98 and not =D98.

The cell C2 tells the code to modify the cell that needs to be hidden.

[nigelbloomy]

If it doesn't have the = sign then you should be able to use something simpler like this:

Please Login or Register  to view this content.

[wunderbarre]

Thanks.

Works a treat.

[nigelbloomy]

I am glad we finally figured it out.