Hi...I am working on a long vba code ...attempting to figure out corresponding "End If" for each If statement. Is there some sort of a key combination in vb ..so I could highlight the If statement and it jumps to corresponding End If.. Thank you.
Hi...I am working on a long vba code ...attempting to figure out corresponding "End If" for each If statement. Is there some sort of a key combination in vb ..so I could highlight the If statement and it jumps to corresponding End If.. Thank you.
No, we use indenting practices to make it visually clear which IF / END IF go together:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you.. but someone wrote the code without indenting and am trying to debug the code. It is very difficult to find out matching End If for some IF statements. I thought there is a hot key combination for this..
Fix it: SmartIndentersomeone wrote the code without indenting
Entia non sunt multiplicanda sine necessitate
If I had to read somebody elses code I'd be using http://www.mztools.com/index.aspx
Look at http://www.mztools.com/v3/download.aspx
Last edited by MarvinP; 01-28-2011 at 08:06 PM.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
shg, MarvinP,
You guys are gonna fill up my hard drive...LOL
Good stuff, gonna give all of these a try....
<heading off to indent my previously written code with shg's indenter>
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks