Microsoft Office Forums - View Single Post - NEWB to Macros - formatting exports

Thread: NEWB to Macros - formatting exports

View Single Post

Old

06-16-2014, 01:47 PM

charlesdh

charlesdh is offline

charlesdh uses Windows 7 32bit

Windows 7 32bit charlesdh uses Office 2010 32bit

charlesdh uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Apr 2014

Location: Mississippi

Posts: 382

charlesdh is on a distinguished road

Default

Hi,

My 2 cents.
You have

Code:

Set ColorRange = Range("A" & jr): L " & jr).Interior"

Should be

Code:

Set ColorRange = Range("A" & jr & ":L" & jr).Interior''changed

As in Bobs code.

Last edited by charlesdh; 06-16-2014 at 01:49 PM. Reason: Opps code correction

Reply With Quote