Posted to microsoft.public.excel.programming

Dave Peterson[_3_] Dave Peterson[_3_] is offline

external usenet poster

Posts: 2,824

Copy paste formula up to a cell using VBA

typo alret!

xlCellTypeLastCell is misspelled in the second sub.

LastRow = .Cells.SpecialCells(xlcelltyplastcell).Row

<<Snipped
--

Dave Peterson

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
Copy/Paste Formula-dropping 1st cell address	kesitton	Excel Discussion (Misc queries)	1	March 30th 10 08:30 PM
Write formula for simple copy and paste to another cell	Kalffiend	Excel Worksheet Functions	1	January 12th 10 09:10 PM
Copy and paste a formula in a locked cell	nsnyder	Excel Discussion (Misc queries)	1	July 21st 09 06:06 PM
Repeat Cell Formula w/out copy/paste?	DTTODGG	Excel Discussion (Misc queries)	1	March 13th 06 05:11 PM
How do I copy a formula/paste w/o losing the cell content?	CShannon	Excel Discussion (Misc queries)	6	June 25th 05 12:39 PM

All times are GMT +1. The time now is 03:00 AM.

About Us

"It's about Microsoft Excel"