PDA

View Full Version : Code Wants help



KK1966
07-03-2008, 11:29 PM
Dear Expert's

I have code below which very thanks to XLD it's I learning form this forum, can some one help's that I wanding it just to paste values only to aviod the formats of original activeWS.


Wb.Worksheets("Sheet1").Range("H13").Copy home.Range("N2")


Thanks very much

JimmyTheHand
07-03-2008, 11:39 PM
home.Range("N2").Value = Wb.Worksheets("Sheet1").Range("H13").Value

KK1966
07-04-2008, 12:08 AM
Greats and perfectly


Thanks Jimmy

mdmackillop
07-04-2008, 12:22 AM
Using the Copy method.

Wb.Worksheets("Sheet1").Range("H13").Copy
home.Range("N2").PasteSpecial xlValues

Bob Phillips
07-04-2008, 01:06 AM
ANother way for the hell of it.



Wb.Worksheets("Sheet1").Range("H13").Copy home.Range("N2")
home.Range("N2").Value = home.Range("N2").Value

KK1966
07-04-2008, 04:19 AM
HI ' EXPERTS

Pleasen have learning much form Yours truly,