What is "relative reference" when writing a macro in Excel? Can it be one cell or a column or a row? I don't understad what it means and what it does.
Please someone explain in plain words..in a simple way b/c I am just learning abt macros.
What does "relative reference" do...in Excel Macros?
Cell addresses can be absolute or relative. If a formula refers to $C$3 no matter where that formula is moved to it will still refer to the same cell (absolute).
If a formula refers to C3 instead and it is moved or copied 5 over and 10 down the cell referred to will be 5 over and 10 down (H13) (relative).
You can mix relative and absolute. A column can remain absolute and a row allowed to be relative ($D4).
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment