Hi.
Is there another way to write this code:
It's a recorded code but when i plug it into my module the code won't execute properly.Please Login or Register to view this content.
Hi.
Is there another way to write this code:
It's a recorded code but when i plug it into my module the code won't execute properly.Please Login or Register to view this content.
No, ws is not defined, nor LR.
Sorry, i posted the middle of the code.
It's a really long code and i didn't want to make things more confusing.
I defined WS and LR earlier in the code.
What is the name of the sheet for ws? Is it Sheets("CustomerList"?
Yes. The name of WS is customerlist
If you have set ws=Sheets("CustomerList") some where in your code, you could omit this line Sheetsand start withPlease Login or Register to view this content.
But this line will also error.Please Login or Register to view this content.
Which range are you selecting before you want to cut that range?Please Login or Register to view this content.
This code does not make any sense, but could give you some direction.
Please Login or Register to view this content.
Here is the entire code.
I indictaed the part that excel is highlighting for me.
Please Login or Register to view this content.
With ws.Range("A" & LR)
means the last row in column A is selected.
You can not insert a row if the last row in column A is above 4.
You could try
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks