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