Hi, this code was doing its job fine over the past 2 days. I didn't change anything. Now all of the sudden I keep getting this error. I've tried to find a solution to people with similar problem but it hasn't been successful....Please help!
Please Login or Register to view this content.
Last edited by soranz; 04-16-2015 at 03:35 AM.
It's working fine for me
Is there any worksheet change event runs in the back ground?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Ok that is strange. It is working for me now too...
To populate "New Data", I've been manually copying a chunk of data from a second workbook into the first workbook's "New Data" sheet.
None of my macro buttons were working either. I did close the workbooks down a couple of times and re-opened and it had that error. Then, I manually added the data. After all of that I saved, checked here, then tried again and now it works.
Could it be the flash drive connection that stored a backup that I might have had a tmp open in the background?
Also, is there a way to qualify that line before I call it?
I requested for all members help for this thread. So surely someone will fix the root cause of this error
Another approach:
Please Login or Register to view this content.
Thank you Sixthsense
Thank you snb!
Quick questions:
What is the data type of sn, sp and st? Seems like they should be ranges but I get errors so I have them as variants.
How can I also rearrange the formatting of the columns along with the data (each column category has a specific color)?
As long as you do not declare them they are variants by default. In this case (arrays) they also have to. If you comment out 'Option Explicit' it runs smoothly.
The formatting is quite another story:
You could add:
Please Login or Register to view this content.
Hmm
Looks like the loop should work. The columns should line up and the colors are copied in the right direction.
For some reason when I run it the colors are very mixed up (data is arranged fine). When I retry they match up in the same messed up way. Some colors I'm not even using in the Main sheet. I have that loop at the very end of the sub.
Any ideas?
It may be better if you use .Color for .ColorIndex
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks