|Feb 24, 2013, 10:20 AM||#2|
I don't know if there's an automated way to do that besides recording a formula being entered to convert to the row/column relative format. But you can manually code it.
Can turn into Cells(row#,col#) = "Something". You can do math inside there so if you want three rows over and one cell down you could do Cells(row() + 3, col# - 1) = "Something".
Hope that helps!
Late 2013 iMac; iPad Air; iPhone 5S; Synology NAS
|Thread Tools||Search this Thread|
All times are GMT -5. The time now is 07:07 PM.