How to hide rows using a macro

minsoo · Apr 22nd, 2002, 04:44 PM

Hi,

I'm trying to de-dup a spreadsheet, and want to write a macro that just compares the value of a column with that of the row before. If there are the same, then I want it to hide the second row. I know I can use a For statement to cycle the column and an If statement to find out if they are equal but is there a command to hide an entire row?

Thanks

Minsoo

James · Apr 22nd, 2002, 05:03 PM

EntireRow.Hidden = True

James

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 22nd, 2002, 04:44 PM	#1
minsoo New Member Join Date: Mar 2002 Posts: 3	Hi, I'm trying to de-dup a spreadsheet, and want to write a macro that just compares the value of a column with that of the row before. If there are the same, then I want it to hide the second row. I know I can use a For statement to cycle the column and an If statement to find out if they are equal but is there a command to hide an entire row? Thanks Minsoo

Apr 22nd, 2002, 05:03 PM	#2
James Board Regular Join Date: Feb 2002 Location: Huntington Beach, CA USA Posts: 327	EntireRow.Hidden = True James