londresw
09-15-2008, 03:58 AM
:banghead:
Does anyone know the technique for how to take a cell reference, stored as a variant type varible in VBA forexcel, say "$B$3" and increase or decrease that by a certain number of rows / columns, to give back for example, "$B$4" or "$A$3".
I'm currently trying to learn VBA for use in an Excel Macro which I hope will help me do some things in my job a bit more quickly.
Does anyone know the technique for how to take a cell reference, stored as a variant type varible in VBA forexcel, say "$B$3" and increase or decrease that by a certain number of rows / columns, to give back for example, "$B$4" or "$A$3".
I'm currently trying to learn VBA for use in an Excel Macro which I hope will help me do some things in my job a bit more quickly.