Hi, i need some help in coding. My code is as below
Can some help help me to amend the code so that
Please Login or Register to view this content.
1) its from E2 to last data
2) look for the word "Difference" in Row1 then down to last data
Will appreciate if you can paste both 1) and 2) code so that i have a better understanding.
What needs to be done if the word "Difference" is found?
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
If the word "Difference" is found in Row1, then go down to last data. Coz currently, my "Difference" is in E1, hence i put E2:E50000. HOwever, they might insert column. Hence my "Difference" might go to F or G.
Just cursor should goto the last data?
Whether always difference will be in First row?
Nono. Its to check for cell.Value<>0 Currently i am using a fix range E2:E50000. However, i wan it to be dynamic.
Ok, I just done a sample of what i am actually doing. I have a cell where i do the checking which is Row C minus Row D.
My code will prompt the user that there is a difference whenever he close/open the workbook. HOwever, my range is E2:E50000 which i am afraid that user might insert column or what.
Hence i need help to for
1) Change the E2:E50000 to E2 to last data
2) Look in ROw 1 for "Difference" and down to last data.
hi, anyone can help?
This seems to work...
Please Login or Register to view this content.
Try this.
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.
Is it possible for u to explain in simple english wat the first few line mean?Originally Posted by bakerman2
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)
Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?
To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
(note: this change is not optional)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks