filmov
tv
Excel VBA - Copy a dynamic range
Показать описание
This method needs only one line of code, but it will not work if your data has empty rows. Hope you like it!
The code will copy from and to the active sheet:
ActiveSheet.Range("B3").CurrentRegion.Copy Range("E3")
The code will copy from and to the active sheet:
ActiveSheet.Range("B3").CurrentRegion.Copy Range("E3")