PaytonsLearningVBA
New Member
- Joined
- Feb 7, 2022
- Messages
- 5
- Office Version
- 2021
- Platform
- Windows
So I know when you have a formula, like A1 + B1 = C3, and you expand it down to row 2, it will automatically change it to A2 + B2 = C2.
Is there anything like this for macro's? I run this macro for every row I have, and I can have up to 50 rows. Currently I am adjusting 50 different codes.
I have the following macro and if I could get the underlined areas (anything with a 3) to automatically change depending on the row they are on, it would be a life changer.
Is there anything like this for macro's? I run this macro for every row I have, and I can have up to 50 rows. Currently I am adjusting 50 different codes.
I have the following macro and if I could get the underlined areas (anything with a 3) to automatically change depending on the row they are on, it would be a life changer.
VBA Code:
|