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

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 03:16 AM.