I have a line of code
The problem is when LastRow = 2
Please Login or Register to view this content.
What is a work around for this?
I can do a + 1, but then the last entry is zero.
I'm also very open to any comments or suggestions on how to write the code better.
Thanks
Full code here:
Please Login or Register to view this content.
Maybe:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
OOPS! Duplicate post...
Last edited by leelnich; 11-29-2017 at 01:40 PM.
Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
Would this work?You can usually skip the Selects, just apply the actions directly to the ranges. Also, it's confusing when both FormulaR1C1 and Formula are used, go with one or the other.Please Login or Register to view this content.
Last edited by leelnich; 11-28-2017 at 04:55 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks