RioDegenero
New Member
- Joined
- Mar 1, 2023
- Messages
- 23
- Office Version
- 365
- 2021
- Platform
- Windows
- MacOS
Hi,
Any help on VBA code to "drag up" formula or "copy" formula up dynamically will be appreciated.
I will like to drag the formula in cell B25 up until B2 preferably (if not then B1 is fine). The starting row will not always be cell B25 every time as per the picture below. So I need the formula to be dynamic.
The formula is "EOMonth(B26,1)"
Recording the code, I have this:
Range("B25").Select
Selection.AutoFill Destination: = Range("B2:B25"), Type: = xlFillDefault
Range("B2:B25").Select
Any help on VBA code to "drag up" formula or "copy" formula up dynamically will be appreciated.
I will like to drag the formula in cell B25 up until B2 preferably (if not then B1 is fine). The starting row will not always be cell B25 every time as per the picture below. So I need the formula to be dynamic.
The formula is "EOMonth(B26,1)"
Recording the code, I have this:
Range("B25").Select
Selection.AutoFill Destination: = Range("B2:B25"), Type: = xlFillDefault
Range("B2:B25").Select