Posted to microsoft.public.excel.programming

theo

external usenet poster

Posts: 66

Macro Help - ASAP - Please!

I have this macro which works great.
But I need to ALSO copy/paste the format of the cells

Sub Macro1()
Sheets("Sheet1").Rows("1:1").Copy
Sheets("Sheet2").Rows("3:5").PasteSpecial
Paste:=xlPasteValidation, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
End Sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
NEED HELP ASAP PLEASE!!	Dragon Blood	Excel Discussion (Misc queries)	7	January 25th 08 03:58 PM
Simple Help ASAP macro to fill range...	Stephen	Excel Programming	4	February 9th 07 12:09 PM
How can I save the formulas when running a macro? Need ASAP!!	MLP	Excel Discussion (Misc queries)	2	November 14th 06 07:50 PM
Need Help ASAP	bigwilly11189	Excel Programming	1	September 29th 05 02:56 AM
Add a form onto a macro - Need help ASAP	TMO	Excel Programming	2	December 13th 03 05:10 PM

All times are GMT +1. The time now is 06:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us