LinkBack URL
About LinkBacks
Hi All
I have written a Macro and I am not an expert at excel things so please assist. I am getting a subscript out of range error and when I go into the code it see below
Untitled.jpg
How can I fix this?
Hi All
I have written a Macro and I am not an expert at excel things so please assist. I am getting a subscript out of range error and when I go into the code it see below
Untitled.jpg
How can I fix this?
You need to write the code asor
Please Login or Register to view this content.
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Try
Please Login or Register to view this content.
Now I am getting the below error
Untitled.jpg
As I am pretty useless when it comes to reading code can you direct me towards anyone that I could possibly sent me file to and send my macro to and they can try to run it and see if they can fix the bugs?? I am close to tears at this stage
Why dont you upload a sample file here ? The format should be the same as your original, just ensure you remove sensitive data.
Put the code here as well using the code tags.
Maybe
Please Login or Register to view this content.
Ok.. here is the file with the information needed to be edited.
Copy of Quote Log (2).xlsx
And this is a copy of the macro
e&m.xlsm
Can you summarize what your code is trying to do, so i can help you correct it?
It is eventually trying to look like this.... or close to it....
test vnhgc.xlsx
Your main data in the Copy of Quote log and Test Vnhgc looks the same. Which parts of the file are you trying to automate?
The macro I am creating is automating the editing and structure of the file..
The information remains the same but it is more refined and edited and sheets and formula's are inserted.
It will be good if you specify which parts (which cell ranges in which sheets)?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks