Hello,
i have interactive table with parameters, and it's updated once a week, and each week table will contain different number of rows. So in VBA how would i define definition that regardless of number of rows i copy that table completely to another sheet.
This is my current code for copying from 8th-76th row, but tomorrow that table could have 90 rows, so how to automatically define in VBA that? Would it help if I name that table? Thank You
i have interactive table with parameters, and it's updated once a week, and each week table will contain different number of rows. So in VBA how would i define definition that regardless of number of rows i copy that table completely to another sheet.
This is my current code for copying from 8th-76th row, but tomorrow that table could have 90 rows, so how to automatically define in VBA that? Would it help if I name that table? Thank You
Code:
Sub Prebacivanje_Prodaja()
'
' Prebacivanje_Prodaja Macro
'
'
Range( _
"D8:D76,G8:G76,H8:H76,I8:I76,J8:J76,K8:K76,L8:L76,M8:M76,N8:N76,O8:O76,P8:P76,R8:R76" _
).Select
Range("R8").Activate
Selection.Copy
Sheets("Stavke").Select
Range("B2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub