Excel features that might replace these Lotus macro tricks?

  • Thread starter Thread starter csphipps
  • Start date Start date
C

csphipps

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.
 
how about something like this to get you started
Sub findoffset()
x = Columns(4).Find(3).Offset(, 1)
MsgBox x

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert from lotus to excel 4
macro or formula to find an account number in another list of numb 1
Excel to Excel data exporting 1
Excel Macro 5
Macro conversion from Lotus 1-2-3 to Excel (Sort Macro) 8
Excel 2003 accepting error message in macro 2
macro to delete lines based on a value - Repost 2
If-then, vlookup, and table display 1

Back
Top