| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to apply the code to the whole of the worksheet?
i have a worksheet in which "ENTRY" and "EXIT" is entered. entry is from A3:D3 and its total comes in E3. exit comes in G3:J3 and its total comes in K3. now E3=k3.
when i enter data in any of the columns of exit and as a result when the total in col K3 does not tally with that of E3 there should be a error message. as per the vbcode in the attached excel file, it works for the row A3. i wanted to apply the code for the whole of the worksheet. how can i accomplish that? thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Apply code to Icon | Excel Programming | |||
| Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
| Apply code to other worksheets | Excel Programming | |||
| run code on opening workbook and apply code to certain sheets | Excel Programming | |||
| macro to apply worksheet event to active worksheet | Excel Programming | |||
Threaded Mode
