Hello Experts,
I am trying to go to the last row of column G and clear 13 rows and 5 columns (Column G through K and 13 rows including last ) using the following code and I am getting runtime error.
[code]Range("G4").End(xlDown).Resize(ActiveCell.Offset(-12, 6)).ClearContents[code]
Please advise.
Best Regards/VKS
Last edited by VKS; 08-20-2017 at 12:05 PM. Reason: Solved
What range exactly do you need to clear ??
Is this helps you
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
This should do it.
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.
Thanks for your time and help Yasser. It didn't work for me.
Thanks Bakerman. Solved and Rep added.
Best Regards/VKS
You're welcome and thanks for rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks