ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel features that might replace these Lotus macro tricks? (https://www.excelbanter.com/excel-discussion-misc-queries/91834-excel-features-might-replace-these-lotus-macro-tricks.html)

[email protected]

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.


Don Guillett

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