I count the number of rows by using awhile loop to go down column A until it finds a blank.
I increment the counter to tell me how many iterations is needed.
I then execute a for loop the desired number of times
I have encountered the same problem.
I use the Format command in Access to set the final format before writing to Excel.
I also make sure that the Excell cell has the same format
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.