variables in last cell
Josh,
Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).Value = myVar
puts it in the next available cell in column A
--
HTH
-------
Bob Phillips
... looking out across Poole Harbour to the Purbecks
"josh" wrote in message
...
this one is a little bit different this time,
i need to output a variable from vba to the next
available cell in a column in my worksheet, any help
would be much appreciated.
thanks guys
Josh
|