I am running this code beow and come up with runtime error 1004 appliction or object defined error
Any help would be greatly appreciatedPlease Login or Register to view this content.
I am running this code beow and come up with runtime error 1004 appliction or object defined error
Any help would be greatly appreciatedPlease Login or Register to view this content.
Last edited by UltimateNeo; 04-10-2019 at 10:37 PM.
Will you please attach a SMALL sample Excel workbook(s) (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).
1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.
2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).
3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!
To attach an Excel file you have to do the following: Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.
Best Regards,
Kaper
The error started when i wanted to add this "And .Cells(i, 8).Value >= 111 And <=170" to the code
Does that help at all?, if not i will upload a file as soon as i get home
Thanks for any help
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks