R
Ronald R. Dodge, Jr.
How do I prevent the Replace dialog box from moving at all within VBA?
Every time I have it find and replace text in VBA, it's moving to the very
bottom of the screen with the lower part of it not even showing. I really
hate this behavior. Right now, I'm going through some major revamping of my
production reporting system, which was initially broke in late 2006 by some
changes that were demanded to take place, which then more or less forced me
to move what formulas I more or less had left on the spreadsheet side to VBA
and not only that, but also forced me to more or less switch from using
standard modules to class modules with the only thing the standard modules
doing is directing. Of course part of that also has required me to use
range names to get around the fact that range references within VBA doesn't
adjust like range references within formulas do, so that's why I have been
forced to use range names, which is also how I learned of the hard code
limit of 65,536 being the maximum number of defined names allowed within a
single workbook, though it's not documented in the spec help file. Even
after half of that limit, the file becomes unstable. As for the limit of
defined names, don't be fooled by it allowing you to continue to work in the
workbook after you exceeded the 65,536 defined names, cause once you have
saved the workbook after exceeding that limit, then close it out, once you
go to open it, it will go into repair mode, which then basically makes the
workbook worthless if you have anything much more than just data, formulas
and VBA code. Pretty much anything else that was done in the workbook,
formats, charts, defined names, all of that stuff is either wiped out or set
to the default settings.
Sincerely,
Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
Every time I have it find and replace text in VBA, it's moving to the very
bottom of the screen with the lower part of it not even showing. I really
hate this behavior. Right now, I'm going through some major revamping of my
production reporting system, which was initially broke in late 2006 by some
changes that were demanded to take place, which then more or less forced me
to move what formulas I more or less had left on the spreadsheet side to VBA
and not only that, but also forced me to more or less switch from using
standard modules to class modules with the only thing the standard modules
doing is directing. Of course part of that also has required me to use
range names to get around the fact that range references within VBA doesn't
adjust like range references within formulas do, so that's why I have been
forced to use range names, which is also how I learned of the hard code
limit of 65,536 being the maximum number of defined names allowed within a
single workbook, though it's not documented in the spec help file. Even
after half of that limit, the file becomes unstable. As for the limit of
defined names, don't be fooled by it allowing you to continue to work in the
workbook after you exceeded the 65,536 defined names, cause once you have
saved the workbook after exceeding that limit, then close it out, once you
go to open it, it will go into repair mode, which then basically makes the
workbook worthless if you have anything much more than just data, formulas
and VBA code. Pretty much anything else that was done in the workbook,
formats, charts, defined names, all of that stuff is either wiped out or set
to the default settings.
Sincerely,
Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000