Posted to microsoft.public.excel.programming

Cimjet[_3_] Cimjet[_3_] is offline

external usenet poster

Posts: 157

Copy/Paste_Value problem.

Hi Everyone
I'm using this vba line to retrieve Values from one sheet but when the values
are formulas, they retrieve the formula instead of the value. I need to convert
it to value and I can't seem to use Paste Special.

Lastrow = Sheets("Summary").Cells(Cells.Rows.Count, "A").End(xlUp).Row
Sheets("Invoice").Range("B2").Copy _
Destination:=Sheets("Summary").Range("A" & Lastrow + 1)
Thank you
Cimjet

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
V-Look up copy problem-PLEASE HELP	Sekhar	Excel Worksheet Functions	3	September 12th 08 09:56 AM
A visual basic value copy BUG?? - accounting format has copy problem!!	[email protected]	Excel Programming	3	June 20th 06 04:42 PM
Copy Problem	sharpie23	Excel Programming	0	October 31st 05 09:06 PM
Copy Problem	[email protected]	Excel Discussion (Misc queries)	6	August 11th 05 12:45 AM
copy problem	Mark K[_3_]	Excel Programming	2	February 26th 04 06:11 PM

All times are GMT +1. The time now is 07:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us