XL97 VBA Paste a variable 1

[vaneagle]

Hi,

Having a mental block!! Code is as below;

Dim openStockCost As String
      openStockCost = Range(nCOL & nROW + 1) 
      WB.Activate
      Sheets("Cost").Select
      Range("e40").Select

how do I paste the value of

openStockCost

into cell e40 ??

Yep its one of those days!! :-(

 

[Bowers74]

Hi Vaneagle,

Why paste? Just set the range's value as openStockCost's value.

Dim openStockCost As String
      openStockCost = Range(nCOL & nROW + 1) 
      WB.Sheets("Cost").Range("e40") = openStockCost

I am assuming that you have Declared and Set WB?

I hope this helps!



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[vaneagle]

Excellent.

Thanks for your answer and thanks for your quick reply!!

Have a star!!