| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel features that might replace these Lotus macro tricks?
The first Lotus macro does is search for an account number, go over a
number of columns to find the tax column, edits the data in the cell to add another amount. The second macro searches the account number, goes over to a certain column and pauses until I put in another account number. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel features that might replace these Lotus macro tricks?
how about something like this to get you started
Sub findoffset() x = Columns(4).Find(3).Offset(, 1) MsgBox x End Sub -- Don Guillett SalesAid Software wrote in message ups.com... The first Lotus macro does is search for an account number, go over a number of columns to find the tax column, edits the data in the cell to add another amount. The second macro searches the account number, goes over to a certain column and pauses until I put in another account number. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get an excel macro to stop at a cell & wait for imput? | Excel Discussion (Misc queries) | |||
| Macro error after switching from Excel 2000 to Excel 2003 | Excel Discussion (Misc queries) | |||
| Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
| passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) | |||
| Macro excel save | Excel Discussion (Misc queries) | |||
Linear Mode
