![]() |
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. |
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. |
All times are GMT +1. The time now is 03:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com