I have this code which will show when a cell has been updated in column P.
I would like it to also update for columns C, K, P & Q Too.
Is that possible?
Any help appreciated.
Please Login or Register to view this content.
I have this code which will show when a cell has been updated in column P.
I would like it to also update for columns C, K, P & Q Too.
Is that possible?
Any help appreciated.
Please Login or Register to view this content.
Try
Set WorkRng = Intersect(Application.ActiveSheet.Range("c:c","k:k","p:p","q:q"), Target)
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Possibly...Please Login or Register to view this content.
Thank you I will try those
One more variant
Please Login or Register to view this content.
Thanks all for the help, they do work.
However I want the chnages to show as independant.
So at the moment if I change column c or p for example the time and date updates in the column.
What I want it to do is show a column update for each individual column, so if c or p change on a different date i can track it.
Does that make sense?
Possibly...Please Login or Register to view this content.
Thank you.
That is perfect and adaptable now
Glad I could help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks