How to hide row's in Excel containing numerous Macros

[CCorr123]

Hi All,

I have a problem with a worksheet I am trying to update.
There is info coming from a separate tab into the main page which I need removed.

I tried deleting the source sheet but it was coming up with runtime error "1004" and "9".
I tried hiding the cells on the source sheet and changing the font colour to white . The wording looks to have "disappeared" but the lines still come through.

Would love to get this fixed if anyone could help me out that would be great!

Using version 2010 .

Thanks!

[xladept]

Hi CCorr,

Welcome to the Forum!

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic