Can someone tell me why it keeps throwing an error on this?How can I accomplish this without selecting or activating? Any help??Please Login or Register to view this content.
Please Login or Register to view this content.
Can someone tell me why it keeps throwing an error on this?How can I accomplish this without selecting or activating? Any help??Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by terriertrip; 01-24-2018 at 08:07 PM.
This isn't correct.
needs to bePlease Login or Register to view this content.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Hello terriertrip,
As alternative, you could use only:
Regards.Please Login or Register to view this content.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Oh yeah, but that didn't seem to fix it. Is there a much more simple way to write this without having to use select. I recorded this from a macro to since the xlDown and the xlToRight is what I'm after, but not sure how that would be coded.
Hello terriertrip,
How about this then,
Regards.Please Login or Register to view this content.
I think this is close Winon. Thank you. The deletion from row 55 needs to somehow incorporate the End.xlDown so I can delete a range of data below 55.
Thank you for the feedback, terriertrip,
You don't say how far down, would it be all the way?...xlDown so I can delete a range of data below 55
A sample workbook would be of great help.
Make sure there is just enough data to demonstrate your need.
Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.
Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Regards.
I will attach a sample if this is not clarification enough. It is only to the last cell used within Col A.
Thank you for your help Winon. It looks like I've got it. Here is the completed code:
Please Login or Register to view this content.
Last edited by terriertrip; 01-24-2018 at 08:51 PM. Reason: edit code
How about this then.
Please Login or Register to view this content.
Last edited by bakerman2; 01-24-2018 at 09:14 PM.
Thank you bakerman2
This will also work, terriertrip,
Regards.Please Login or Register to view this content.
Sorry terriertrip,
What I wanted to say was that this code could be applied to any sheet.
Regards.Please Login or Register to view this content.
Post duplicated, and was removed.
You're welcome and thanks for rep+.
Thanks Winon. Much appreciated.
Hello terriertrip,
You are welcome, glad I could assist in some way. Also, thank you for the Rep. I appreciate it!
Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks