I have a workbook that I want to take all the information in specific cells and put them into a database. I have created a string called myCopy, but when i set it as a range it's giving me an error.
HTML Code:
here is the attached workbook
Chemical Field Ticket.xlsm
thank you
You can't set a range like that... but try this one:
Changes in red.
Please Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
thank you very much. This fixes the error but I want the total "F35" to be in column C in the database. It won't record the f35 value and is showing up blank. is that because the array needs to be in order from cells left to right?
ty for the rep jmcconvile
Does that mean it worked for you? If so, please mark the thread as solved?
Oh I see you posted...
I don't follow... specific questions are hard to answer with no context....
I can tell you what you are trying to do exactly, but I'll try to figure out what the code does
no it shouldn't. It's a formula based on the subtotal and sales tax on the excel sheet. I'm just trying to reorder this in the database and have it put F35 into column C
The range is probably in order, the first cell would be C6, not F35 regardless of how the range is set up (which was F35 first)
is there anyway to change that?
I can see that it did in fact add the total to the end of the database. so it must just be the order it puts it in
Bit hard to do this without the data... but I went back to using the array instead of the range for the part that copies values... see if it does what you want?
Please Login or Register to view this content.
You can of course set a range like that but in your case the myCopy string is exceeding the 255 characters limit.
To handle this situation, you may declare two strings like myCopy1 and myCopy2 and then use Union to set a range.
Try this.....
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
with that last code i get "Invalid next control variable reference". the cell on the input sheet displays $477
Chemical Field Ticket.xlsm
thanks for your help. With this code i have the same problem. It seems to be assigning each cell to the database columns by numeric order. The F35 cell is still being put in the last column of the database even though it's shown 1st on the list
oops needs fiixng.
Last edited by Arkadi; 06-19-2015 at 11:41 AM.
using your last response I still get an error eluding to Next myCell. it says invalid next control variable reference
OOOOh... doh thought i'd fixed before pasting... change "next myCell" to "next i"
what variable should I define "i" as? I defined it as a long after receiving the "variable not defined" error
Here is what I have. The red is where the error comes up saying Variable not defined
HTML Code:
Well that's not with my posted code, but yeah in my version it would need a dim i as long
the next error I get, after defining i as long, is "variable not defined" for the myCopy in
HTML Code:
HTML Code:
That's because it is a combination of 2 versions... mine being part of it. With this:
it is probably closer, but I think you said something about $477 ending up somewhere, not sure what that was about, but I had forgotten to change "next myCell" to next i.. which I fixed here.Please Login or Register to view this content.
that works! thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks