Maybe there's something I don't know, but I'm using Offset to find values in one cell and export them to another cell. There have been a few times, where Offset is not what I would expect. For instance, in the code:
The second argument for Offset sometimes isn't what I would expect it to be and I'm not sure why this is. Hopefully someone can shed some insight into this? Thanks
Please Login or Register to view this content.
Last edited by Blackhawks; 11-22-2016 at 11:04 AM.
Hi Blackhawks
Don't know if this is the issue...can't test.
You're missing a Dot (.) here...
Should be...Please Login or Register to view this content.
Please Login or Register to view this content.
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.
I've tried addingBut it doesn't change anything. I'll try uploading some data tomorrow to test it out. I've used Range without the Dot before, do you know why this would matter?Please Login or Register to view this content.
Hi Blackhawks
Yes...way to late tonight for me to explain...in bed...I've used Range without the Dot before, do you know why this would matter?
Try more "missing Dots" (.)
Please Login or Register to view this content.
Hi
Do you have any merged cells in your worksheet?
Don
Please remember to mark your thread 'Solved' when appropriate.
No, no merged cells. The only thing that I could think of is that I used a VBA script to pull the data from a csv file. So It goes something like this, I imported the data from a csv file. Filtered it using a vba script to go into another worksheet (Containing all sales), now I'm using the current vba script to pull only select data into a new worksheet. Perhaps the data is retaining old reference data?
Are you saying that the data is not where you expect, or that Offset(0, 15) is actually referring to a cell 4 to the right of the ALS cell? The latter is impossible so I would surmise that your import process has put data where you do not expect it to be.
The latter. For instance, Offset(0, 15) actually refers to what (I would think) should be Offset(0, 4). What can I do about this? Because the Import process worked (i.e., all of the cells are where they should be with the exception of one weird quirk that I noticed on import, but I dismissed it). Is there a way to clear any underlying reference data? I'm pretty lost and I'm afraid I don't know how to get this done.
Does anyone know of any websites that you can pay to get excel help? I need to complete this and although I technically have it working right now, I'm afraid of giving it to my client because I don't know it will crash or bug out later. I want it to be solid.
This covers about all necessary dots in your code so miscounting shouldn't arise anymore.
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.
Bakerman2 - thank you!! This worked. Do you mind telling me why it worked exactly? I tried adding dots to Range and Rows, but it's adding SendToMRP.Rows that made it work.
And thank you to everyone else that helped me with this!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks