Selection.Copy ????

[Mungovan]

Hi!
This is really a VB question in Excel, but I hope someone can still help me???

Basically I have some code that copies the contents of cell E1 in Sheet B, and then pastes that numerical value to cell B1 in Sheet A.

The trouble is that I'm copying a cell that is a sum of other cells i.e Cell E1 in Sheet B is =Sum(A1:A4).

So I get errors when I try to copy that value. The computer can't seem to copy a value that is derived from a formlae???

What can I do???

Thanks a mill,
D

 

[ETID]

try this instead of copying


sheets("sheetA&quot.range("b1&quot=sheets("sheetB&quot.range("E1&quot

 

[xlbo]

Hi - use:
selection.PasteSpecial Operation:=xlPasteValues

HTH
~Geoff~

 

[Mungovan]

Hi,
Well, the problem really isn't in the pasting, it's in the selecting

Even when I try to just select the cell I get an error.


P.s. - I had previously done that paste special in my code, but I can't even copy the data in order to paste!!!

Thanks again for any help????
D

 

[bryanbayfield]

What error are you getting when you try to select the cell using VBA?

You shouldn't use cell(x,y).select when you're copying and pasting anyway, not unless processing time is of no consequence to you.

Personally I;d use ETID's assignment statement.

 

[xlbo]

If you wanna go down that route, shouldn't you explicitly tell excel which bit of the cell you are using ie value / formula / text....
sheets("sheetA&quot.range("b1&quot.value = sheets("sheetB&quot.range("E1&quot.value

HTH
~Geoff~

 

[bryanbayfield]

Geoff, Value is the default property of the range object.

You have to be careful if you start setting user-defined ranges as well though ... in fact in that event I would start actually specifying .Value after the range in my assignment statements.

 

[xlbo]

cool - think I'll carry on specifying tho - even if it's just for my clarity
Thx Bry HTH
~Geoff~