intcol

I found this thread to set a background color to the column header of the column with an autofilter applied. It works fine on the Worksheet Activate event, but not for the Worksheet Change, Calculate, or Selection Change. Not sure which on I need, but I'm just looking to apply the background...

I am using this bit of code in my macro I found to nearly work but could someone please tell me what this means For lRow = 353 To 2 Step -1 does it only go down to row 353? I want it to work on columns B & C only, thanks The full code is: Dim lRow As Integer Dim intCol As Long Dim rngCell...

Hi, I am trying to delete and shift cells up for multiple columns but can't seem to get this to work. Any help is appreciated! Task: If columns F through K are blank, then delete and shift cells A through K up. (note: I'm trying to shift additional columns A through E) Here is the code I...

Hi there, I have a range (BA103:DA114) and I am looking for a simple way to remove any blank rows. However, I only need this range of 10 rows to be in the equation as there are other cells to the left and right and also below this range which contain data... (if you get my drift) I can delete...