getting the value into a cell instead of the formula..

Posted to microsoft.public.excel.programming

Neeraja

external usenet poster

Posts: 5

getting the value into a cell instead of the formula..

Hi,

I try to copy a value to a different sheet in the
workbook through the below line

Worksheets(Esheet1).Cells("B5").Copy _
Destination:=Worksheets("DummyData").Range("A1")

B5 contains the product number(this is some formula). In
A1 i get "#Ref!" instead of the product number. what do i
do to solve this..
Any help would be appreciated.

Thanks,
Neeraja.

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
How can I make a blank cell in a formula cell with a range of cell	Vi	Excel Discussion (Misc queries)	5	June 21st 07 02:46 PM
adding a formula in a cell but when cell = 0 cell is blank	Mike T	Excel Worksheet Functions	5	May 31st 05 01:08 AM
Cell Formula reference to cell Based On third Cell Content	Gabriel	Excel Discussion (Misc queries)	1	February 11th 05 06:36 AM
Cell Formula reference to cell Based On third Cell Content	Gabriel	Excel Discussion (Misc queries)	0	February 11th 05 05:35 AM
Question: Cell formula or macro to write result of one cell to another cell	Frederik Romanov	Excel Programming	1	July 8th 03 03:03 PM

All times are GMT +1. The time now is 12:55 AM.

Menu

About Us