#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 21
Default Macro Step by Step

I thought that a Macro can be run "Step by Step", activating this button
instead of "Run".
When I do this, the Macro stops at the start (Title) of the Macro and then
nothing!
How can I execute it Step by Step in order to see where the bug is ?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 179
Default Macro Step by Step

go visual basic editor (Alt+F11), and go your macro area and press F8

pls do rank for me

"fak119" wrote:

I thought that a Macro can be run "Step by Step", activating this button
instead of "Run".
When I do this, the Macro stops at the start (Title) of the Macro and then
nothing!
How can I execute it Step by Step in order to see where the bug is ?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default Macro Step by Step

Just keep hitting F8 to step through

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"fak119" wrote in message
...
I thought that a Macro can be run "Step by Step", activating this button
instead of "Run".
When I do this, the Macro stops at the start (Title) of the Macro and then
nothing!
How can I execute it Step by Step in order to see where the bug is ?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
error when running cut & paste macro Otto Moehrbach Excel Worksheet Functions 4 August 9th 06 01:49 PM
link to combobox legepe Excel Discussion (Misc queries) 4 July 26th 06 04:45 PM
Macro question Chris Excel Worksheet Functions 12 July 7th 06 01:23 AM
Compiling macro based on cell values simonsmith Excel Discussion (Misc queries) 1 May 16th 06 08:31 PM
Search, Copy, Paste Macro in Excel [email protected] Excel Worksheet Functions 0 January 3rd 06 06:51 PM


All times are GMT +1. The time now is 09:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"