gabriellejayde
New Member
- Joined
- Apr 18, 2022
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
I am not great with macros and can't figure this one out. This is the current macro we use to copy a cell range:
Sub CopyInventory()
'
' CopyInventory Macro
' FROM INVENTORY MANAGER
'
Range("F33:O5000").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
End Sub
So it's copying almost 5000 rows. column F is filled with a formula down to row 5000, but often we only have a few hundred rows of columns G-O filled. Rather than always copying down to row 5000, I'd like to only copy columns F through O down to the last filled row in column G. (because column F is filled with a formula).
Does anyone know how to do this?
Sub CopyInventory()
'
' CopyInventory Macro
' FROM INVENTORY MANAGER
'
Range("F33:O5000").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
End Sub
So it's copying almost 5000 rows. column F is filled with a formula down to row 5000, but often we only have a few hundred rows of columns G-O filled. Rather than always copying down to row 5000, I'd like to only copy columns F through O down to the last filled row in column G. (because column F is filled with a formula).
Does anyone know how to do this?