| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you have a macro always running on a sheet waiting for data
The subject line, pretty much sums it up. This is the macro I have, as I
input data I want it to change without executing the macro, (i.e, the purpose of the question.) Range("A1:A65536").Select Selection.Replace What:="39", Replacement:="0", LookAt:=xlWhole, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Waiting for Input in a macro | Excel Discussion (Misc queries) | |||
| Waiting for data to be returned from Microsoft Query | Excel Discussion (Misc queries) | |||
| Waiting Mode when query data from Db via VBA! | Excel Programming | |||
| Running Macro on every sheet in Workbook !!! | Excel Programming | |||
| waiting for data refresh before continuing VBA sub | Excel Programming | |||
Threaded Mode
