LinkBack URL
About LinkBacks
Looking to pass an array into the cells using code similar to this:
Please Login or Register to view this content.
Please Login or Register to view this content.
Looking to pass an array into the cells using code similar to this:Please Login or Register to view this content.
Please Login or Register to view this content.
I'm not actually sure what you need help with. Also, I am not a fan of all your input boxes that pop up in your macro. What happens if someone makes a mistake and press enter? How do they go back and fix it?
Mally,
I am trying to streamline the code from:
to something within a line or four. I know it can be done, but I don't understand the code. I am too new to this.Please Login or Register to view this content.
As far as error correction goes, the bill is printed onto the screen (using the above code) and then:
It allows them to identify where the error is and correct the whole line.Please Login or Register to view this content.
Unsolved thread. Bumping
lloydgodin,
Working off of your original post, it won't be quite that simple. You can avoid the loop, but it will be several range().value = transpose(array). This is because you are using many 1-dimensional arrays instead of a single 2-dimensional array. Here's the code that will avoid the loop though:
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
works great. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks