Macro Question...

  • Thread starter Thread starter Hugh Stanley
  • Start date Start date
H

Hugh Stanley

Well, macros were easy enough in 1-2-3, but I've forgotten enough
since then to not even be able to do those using the Excel translation
functions. So, here's the deal.

When one tries to do macros in Excel, using the "record macro"
function it does things different than what I want it to do, and I
just can't get my arms around it in fast enough time, so throw me a
bone if you can...

Say you've got a huge pile of information in a bunch of rows in an
excel spread sheet. And some of them are duplicate grids you want to
delete. So you want to go into one of the similar text grids, (F2)
copy the information, (Ctrl-C), then delete all similar grids with the
same information in them (Ctrl-H), (Ctrl-V), and then delete anything
that matches that grid.

ONLY, if you do this while recording a macro, it will record the
particular text that you copied instead of the action of "go to the
grid I start at and copy whatever information is there".

How do you DO that, ...can you do that in the record macro mode? If
you can't what's the incantation that gets it done?

Thanks, hope this makes sense.


- Hugh -
 
Record macro will just record the keystrokes that you make, and the results
of what you do. It is useful for getting some of the functions, the syntax
etc., but it invariably needs some tweaking to get the dynamic code, and the
precise results that you want.

Then you need to know VB, and un derstand the object modeul to change it to
be effective.

Post some explicit question with examples of your code to date for real
help.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top