Creating Macros

  • Thread starter Thread starter Brook
  • Start date Start date
B

Brook

Does anyone have any tips, tricks, or helpful Website that
would help me in the creation of a Macro. What I am wanted
to do is create a Macro that would "text to column" a
fixed length activity file.

Thanks
 
Brook, here is a link to start with
http://www.mvps.org/dmcritchie/excel/getstarted.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
The easiest way to get started with a macro is to use the
start the Macro Recorder then just manually perform the
task on the sheet and then stop the recorder. Then goto
Tools/macro/visual basic editor and you will find the
macro code already written for you.

Read the articles the ohters have suggested and use the
Visual Basic help system to understand the commands you
see.
 
Back
Top