Macro help please

ironsides

Well-known Member
Joined
Aug 12, 2002
Messages
575
Im going to use the word rules for vertical lines
generated with the Borders option


Is there a macro that will delete rules and colors
in selective lines as described below?

Cols from A thru CC
There are 50,000 lines
Data starts on line 3

Line 3 has data
Line 4 blank
Lines 5 thru 9 has data
Line 10 to 13 are four blank lines
Lines 14 thru 19 has data

Data and blank lines vary and are not uniform

This continues for the 50,000 lines

Using the Border option I have vertical rules
and colors in varying cols from A thru CC
in lines 3 thru 50,000

I want delete the lines and colors in blank lines only

So line 3 with data to keep vertical rules and color
Line 4 with no data to have no rules and no colors
Lines 5 thru 9 with data to keep vertical rules and colors
Lines 10 thru 13 with no data to have no rules and no colors

Etc

Thanx ironsides
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

chiello

Well-known Member
Joined
Jan 18, 2005
Messages
848
Hi Ironside,
I'm not going to provide a solution, but just a couple of ideas to solve your request.

I suggest two solutions (if you want VBA code you can record a macro while performing actions):
1) You can apply an autofiter o your work range (i.e. A1:CC50000) and filter all fields on empty cells;
2) Use an auxiliary column where insert a formula to count blank cells on relevant row (from A to CC), then filter the auxiliary column with the number of columns frm A to CC;

Once you have filtere (either with solution 1 or 2), remove rules and colors from visible rows.

Hopetis can help

Regards

Andrea
 

ironsides

Well-known Member
Joined
Aug 12, 2002
Messages
575
Bump

Can this be done?

Macro help please


Im going to use the word rules for vertical lines
generated with the Borders option


Is there a macro that will delete rules and colors
in selective lines as described below?

Cols from A thru CC
There are 50,000 lines
Data starts on line 3

Line 3 has data
Line 4 blank
Lines 5 thru 9 has data
Line 10 to 13 are four blank lines
Lines 14 thru 19 has data

Data and blank lines vary and are not uniform

This continues for the 50,000 lines

Using the Border option I have vertical rules
and colors in varying cols from A thru CC
in lines 3 thru 50,000

I want delete the lines and colors in blank lines only

So line 3 with data to keep vertical rules and color
Line 4 with no data to have no rules and no colors
Lines 5 thru 9 with data to keep vertical rules and colors
Lines 10 thru 13 with no data to have no rules and no colors

Etc


Thanx ironsides
 

Watch MrExcel Video

Forum statistics

Threads
1,122,656
Messages
5,597,390
Members
414,141
Latest member
Joey_T92

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top