Hello all,
I am having an issue making a VBA code that converts units of measurements.
I want to change my code where instead of the cell location is in this form "R[-2]C[-21]" but instead this from "G4"
Please Login or Register to view this content.
Thanks,
Ehizzle
Instead of the .formular1c1 property, use the .formula property (help file with links to these and other properties of the range object https://msdn.microsoft.com/en-us/lib.../dn301006.aspx ). Though, before you abandon r1c1 notation, I will note that there are advantages to using r1c1 notation when working in VBA, which, I expect, is why the macro recorder prefers to record macros using the .formular1c1 property.
I would note that, in cell AB16, R[-2]C[-21] does not refer to G4, but refers to G14. Syntactically, it doesn't matter, just to be sure that you are clear what cell you want the formula to refer to.
Originally Posted by shg
Try changing this
to thisPlease Login or Register to view this content.
Please Login or Register to view this content.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Special-K,
This solved my issue! Thank you very much sir!
-Ehizzle
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks