View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default vba code line number

grab a copy of mz tools for vba

http://www.mztools.com/index.htm

--


Gary


"kdp145" wrote in message
...

hello,

i was wondering if there is an option in VBA to display line numbers of
the code. we are migrating to a new server space and i need to change
database and file locations in my code, so i am just trying to map out
on which lines i would need to change the code. so far my best option
is to just keep a track of the module and the procedure name in which
the code needs to change, but going through a lot of procedures is time
consuming.


--
kdp145
------------------------------------------------------------------------
kdp145's Profile:
http://www.excelforum.com/member.php...o&userid=29594
View this thread: http://www.excelforum.com/showthread...hreadid=559319