How to have Mixed References in Macros
Closed
Chris
-
9 Feb 2010 à 13:54
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 9 Feb 2010 à 15:02
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 9 Feb 2010 à 15:02
Related:
- How to have Mixed References in Macros
- Excel online macros - Guide
- Keyboard keys mixed up - Guide
- Unlock excel vba and excel macros - Guide
- Refer to the graphic what type of cabling is shown - Guide
- How to run a macro in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
9 Feb 2010 à 15:02
9 Feb 2010 à 15:02
Not know how your macro, but in general $ sign will make it absolute
$B1 says column B is fixed and row will change
B$1 says row is one and col will change
$b$1 is both fixed
$B1 says column B is fixed and row will change
B$1 says row is one and col will change
$b$1 is both fixed