View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Code to Resize a variable number of rows including target

You should be aware that the word "Err" is a keyword as in your line...

MsgBox Err.Description

...which refs the errors colection, and so I'm curious why you also use
it as a GoTo label. Better this way...

On Error GoTo ErrExit
'..code

NormalExit:
Exit Sub

ErrExit:
MsgBox Err.Description

...so your code is easier to understand what's going on. You might think
it's good for now but 6 months down the road will not recall your
reasoning. Also, another developer has to 'figure out' what you're
code's intent is. (Albeit this is fairly simple, bad habits can cause
greater problems!)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion