View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett
 
Posts: n/a
Default 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.