NEWB to Macros - formatting exports

		Microsoft Office Forums > Microsoft Excel > Excel Programming
NEWB to Macros - formatting exports

#11

06-16-2014, 01:47 PM

charlesdh

Windows 7 32bit NEWB to Macros - formatting exports

Office 2010 32bit

Expert

Join Date: Apr 2014

Location: Mississippi

Posts: 382

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

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formatting contents after Tab of continuous lines or formatting specific area of word	pawii	Word	1	05-12-2014 05:24 AM
macros	stebrownsword	Word VBA	0	08-28-2013 01:16 AM
How to do Formatting Using Macros	anju16saini	Word VBA	1	03-11-2013 04:15 AM
Formatting with macros	WaltR	Word VBA	8	05-15-2012 06:28 PM
Macros	nore	Outlook	0	06-01-2011 04:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:20 AM.