filmov
tv
Excel VBA - Copy a dynamic range
![preview_player](https://i.ytimg.com/vi/naecS0GS3bM/maxresdefault.jpg)
Показать описание
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")