Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Macro
- Thread starter bigb
- Start date
Assuming EXCEL:
open the file
Start the "macro recorder"
Allways the same cells?:
Leave the "button" "relative reference" off
Relative to current positin?
set the "button" "relative reference" on
Do what you wish the macro to do and press "stop" when finished.
Open the VBA editor and edit anything you want (e.g. range or filename)
Best Regards
Morten
open the file
Start the "macro recorder"
Allways the same cells?:
Leave the "button" "relative reference" off
Relative to current positin?
set the "button" "relative reference" on
Do what you wish the macro to do and press "stop" when finished.
Open the VBA editor and edit anything you want (e.g. range or filename)
Best Regards
Morten
- Status