Hi All
I am looking for a small piece of code to use in a Worksheet_Change event please.
Basically when a figure is entered on Column C I want to add that value to the figure in Column D on the same row as the change.
Any help appreciated.
Many thanks in advance.
Tony
Hi, Tony,
maybe something like this (right click on worksheet tab, choose ViewCode, paste into code window):
This will check for a change of one cell first and not fire the event in casae more than one cell is changed. After that itīs checked if column C has been altered. And then there are two checks for numeric values in both Column C and Column D before the cell in Column D is updated.
Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks