Related:
- Paste at end of data
- Tmobile data check - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- This message was deleted text copy and paste - Android Forum
- How to be offline in whatsapp when data is on - Guide
- Data transmission cable - Guide
2 responses
Here you are:
Sheets("Format").Range("AC10:AQ15").Copy Destination:=Sheets("TT - M").Range("AC" & Rows.Count).End(xlUp).Offset(1, 0)
Note that it is End(xlup) not End(x1up).
Sheets("Format").Range("AC10:AQ15").Copy Destination:=Sheets("TT - M").Range("AC" & Rows.Count).End(xlUp).Offset(1, 0)
Note that it is End(xlup) not End(x1up).
That's great and working now - Thank You.
Can you tell me what the Range("AC"&Rows.Count).End(xlUp) actually does?
I thought ("AC"&Rows.Count) would go to the last row with data
And then End(xlUp) will move up ?
Sorry if this is a silly question, but I'm a self taught beginner and just finding my way.
Thank You,
LV.
Can you tell me what the Range("AC"&Rows.Count).End(xlUp) actually does?
I thought ("AC"&Rows.Count) would go to the last row with data
And then End(xlUp) will move up ?
Sorry if this is a silly question, but I'm a self taught beginner and just finding my way.
Thank You,
LV.
it goes to the last row in the sheet. and then goes up to the last row with data.
So, it'll jump to say, AC65535 (excel2003), and then up to AC50 if the cell in that row has data in it. The offset will then go down a single row ready for input.
is that not what you need? I was a bit confused by you having AC7 but that didn't match your requirement.
So, it'll jump to say, AC65535 (excel2003), and then up to AC50 if the cell in that row has data in it. The offset will then go down a single row ready for input.
is that not what you need? I was a bit confused by you having AC7 but that didn't match your requirement.
