Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel macro
Name: Barky Date: August 19, 2000 at 15:23:37 Pacific
Comment:
I need an excel macro that will go to cell A1, copy the value and then look for that value (find) in a range. The value varies, so I need to have it copy the value as it exists and then paste the value as it exists (into the find dialog). I noticed it will copy the current value but when you paste it is not the current value, it is the value that was first recorded into the macro. I have tried various referencing types- relative, absolute, and a mixture of the two.
Name: jmatt Date: August 19, 2000 at 15:56:08 Pacific
Reply:
Don't know the answer to your question , but you may be interested in UnFrag . UnFrag -- Win9x, WinNT4, Win2K If you are extremely particular about your hard drive maintenance, check this out. UnFrag searches for compound document files. Compound document files are created by applications such as Word and Excel that support Object Linking and Embedding (OLE) and are not normally recognized as being fragmented by your Defrag utility. Unfrag lets you get a handle on these files. PokPok has used Unfrag for a couple of years and endorses it without reservation. (Last updated: 5/23/00)
Summary: Hi, I need to delete 1-2 rows of repetitive text which occurs on my spreadsheet at non regular intervals. I know how to delete to empty rows using an excel macro. But I need a macro to delete specifi...
Summary: We are mainly a UNIX environment so need processes that we can automate in a non-gui world, even if it has to be in a Microsoft environment. Basically we need to set up an automated process in which ...
Summary: I'm open to correction, but I don't think you can - a macro records key and cursor instructions, but when you "Save as HTML" a wizard takes over, which isn't recorded because it's doing more than just...
0 
