i'm struggling to get this to work it's supposed to put date/time in offset cell if cell changed but it fires on selection
iPlease Login or Register to view this content.
i'm struggling to get this to work it's supposed to put date/time in offset cell if cell changed but it fires on selection
iPlease Login or Register to view this content.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Try using a Worksheet_Change event macro
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assisted or failed to assist you I welcome your Feedback.
oops! thanx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks