I know there are several ways to do this but I was wondering if there is a "best" way (and why) to find the number of rows in an excel spreadsheet through VBA code.
Thank you!
This may be an easy question but I'm having trouble getting this to work. I'm working in Excel 2000 and I've got an imported table that has 16 columns and a variable number of rows. Most of the time, each row has info in only one of the data columns (see below). I need to first determine if...
I need to change the .ColumnHidden property on fields in a subform. I can change it without problem if I'm on that form with
Me!Payments.ColumnHidden = -1
but can't seem to change a Child form's field properties from code in the Parent form. I've tried several variations of this code...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.