Macro to Hide rows based on 'Sum'

[rakeshplb]

Hi,

I want a code to Hide the row if "sum of numbers in columns three thru last column" = 0.

Following is a code I use to delete a row if that is blank. The difference here is that I dont want to to check first two columns and I want to hide them rather than deleting.

Can someone help on this...

Please Login or Register  to view this content.

[davesexcel]

You can get a lot of code information by using your macro recorder.

Please Login or Register  to view this content.

[rakeshplb]

I want to hide rows based on 'sum' of cells in column 3 till last column.
The code here is based on Count and is for Entire row. I want the code to ignore first two columns.

[Domenic]

Try...

Please Login or Register  to view this content.

[Domski]

Cross post: http://www.mrexcel.com/forum/showthread.php?t=437821

@rakeshplb, please read this: http://www.excelguru.ca/node/7