Custom Ranges and Getting LastRow to Work with Copy and Paste - Excel VBA

Опубликовано: 19 Сентябрь 2024
на канале: ExcelVbaIsFun

37k

121

Free Workbooks:
Join Excel Ninja Pro: Months FREE On Annual Plan Auto Applied)
Excel Ninjas FB Group: (Free downloads, Trainings, Live Q&A and more)

In this lesson we find a common set of issues when using copy and paste, rather than setting values from each cell individually. Sometimes spaces are pasted in your table or sheet and it can mess up subsequent LastRow commands. We fix this by using a more custom range to help. Also we can delete the spaces so the last row is again accurate.

Fantastic Developer Tools:
Transform Any Excel File Into A Locked EXE: (25% off with code ‘25OFF’)
Create Custom Installers:
Business Inquiries, Consulting, Comments, etc: