|Feb 24, 2013, 09: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!
2012 15" Macbook Pro 16GB RAM/256GB SSD; iPad 4 - Black; iPhone 5 - Black; Synology DS411+II NAS 12TB
|Thread Tools||Search this Thread|
All times are GMT -5. The time now is 06:03 PM.