Hi All,
I'm having trouble with the following:
1. Need to check each row individually - and if from columns b through n and column r are changed - modify column a to say "updated".
I'm using the code below for the continuous range - but I need it b-n and then r...
Also it seems to work once - then doesn't not work again.
Help????
Please Login or Register to view this content.
Last edited by arlu1201; 08-27-2012 at 07:25 AM.
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.
---------- Post added at 04:56 PM ---------- Previous post was at 04:55 PM ----------
Do you want to check only the row that data is being entered to? or the whole data set?
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.
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
I have about 50 rows - each row lists a set of standards and parameters. If any cell in that particular row is modified, then I need to have the first column changed to "Updated" for that row (letting the programmers know they have to review that rows content). Then I need to go to the next row the User changes and do the same...
They can skip rows or even go back and change one that they passed earlier...
Hope that helps...
---------- Post added at 01:32 PM ---------- Previous post was at 01:29 PM ----------
For some reason it isn't working... and sometimes it works once and then won't ... is there something I'm missing to clear the memory?
---------- Post added at 01:36 PM ---------- Previous post was at 01:32 PM ----------
thanks on the code tabs - as you can tell I'm new to the forum
try to put this line
on the end of procedure (just above "end sub" statementPlease Login or Register to view this content.
I copied everything directly - and it is not changing column 'a' at all... in fact it acts like it is not running the macro...
open immediate window and copy there this line
and press EnterPlease Login or Register to view this content.
Last edited by tom1977; 08-27-2012 at 07:50 AM.
I'm sorry if I'm being difficult - but I did...
Here is what I have and it is not working at all - no modification to column A:
Please Login or Register to view this content.
deleted post
Last edited by tom1977; 08-27-2012 at 08:06 AM. Reason: duplicated post
On my computer it works ok did you do what I asked in post #7? If You do not know where is this window look into attachment Attachment 176680
That was it!! Thank you for the gif... it showed exactly what I needed :-)
Again - thanks you really made my day!!
@ ghoshl1
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.
Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Hi - I thought I had marked it as solved... where was that at?
---------- Post added at 05:05 PM ---------- Previous post was at 05:05 PM ----------
Oh - I got it sorry!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks