I really appreciate the help...
when I step through it the error occurs here:
For Each cell In rInp.Cells
sInp = cell.Value
it steps from the For statement going to the sInp and errors there.
I am obviously not great at this code thing either...still trying to pull what little knowledge i had from the cobwebs of my mind.
Thanks again,
John
Hi John
Are you running this code on the sample workbook you posted in your thread? If not, run on your sample and see what happens. The sample is a controlled environment and, on my platform, the code steps right through that line.
If you're running on a different sample, you'll need to post that.
John
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks