Posted to microsoft.public.excel.programming

Jeff

external usenet poster

Posts: 921

pastespecial

Hi,
Can someone please help me with the following task:
I am trying to copy a block of cells from sheet1 (starting from
Cell("B1")) and ending on the last cell (most right, most down cell, which
may vary on each execution), paste only values into sheet2.

Thanks,
Jeff

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
PasteSpecial	KL[_3_]	Excel Programming	1	July 8th 04 02:07 PM
Pastespecial and cut	Ron[_23_]	Excel Programming	4	April 26th 04 02:14 AM
pastespecial in vba	cornishbloke[_13_]	Excel Programming	7	December 31st 03 01:02 PM
vba pastespecial	joao	Excel Programming	2	November 14th 03 03:31 PM
pastespecial	billQ	Excel Programming	2	July 29th 03 11:39 PM

All times are GMT +1. The time now is 02:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us