Error in VBA Coding in Macro
I need help with a spreadsheet. It's supposed to function like a
similar one. Links to both below. Basically, you'll notice some shaded boxes on the worksheets. I have people who use this form and generate receipts. Now what happens is they fill in the 'form' and press the ENTER button. A sheet is created everyday that copies some pertinent information over into a log. The first sheet is generating errors and not entering information in the right areas. Detailed description: When I press the ENTER button, everything else works correctly but the information being transferred from the Cash Receipt form to the log is starting on Row 3 instead of Row 5. Also when I tested it, it'll copy over the first TWO receipts perfectly (at least it will copy it over to Rows 3 and 4) but will not accept anything after that. I'm wondering if any VBA guru in this group and see what I'm missing on the macro contained within the spreadsheets. I just can't seem to locate the error in the coding. Scroll down, hit the FREE button, type in the three letter authorization code, and hit download if you wish to download the files. Problem - http://rapidshare.de/files/12319763/...g_H2O.zip.html Working - http://rapidshare.de/files/12783159/...aster.zip.html |
Error in VBA Coding in Macro
Don't see anything on those links apart from a hosting advert.
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Pooja" wrote in message ups.com... I need help with a spreadsheet. It's supposed to function like a similar one. Links to both below. Basically, you'll notice some shaded boxes on the worksheets. I have people who use this form and generate receipts. Now what happens is they fill in the 'form' and press the ENTER button. A sheet is created everyday that copies some pertinent information over into a log. The first sheet is generating errors and not entering information in the right areas. Detailed description: When I press the ENTER button, everything else works correctly but the information being transferred from the Cash Receipt form to the log is starting on Row 3 instead of Row 5. Also when I tested it, it'll copy over the first TWO receipts perfectly (at least it will copy it over to Rows 3 and 4) but will not accept anything after that. I'm wondering if any VBA guru in this group and see what I'm missing on the macro contained within the spreadsheets. I just can't seem to locate the error in the coding. Scroll down, hit the FREE button, type in the three letter authorization code, and hit download if you wish to download the files. Problem - http://rapidshare.de/files/12319763/...g_H2O.zip.html Working - http://rapidshare.de/files/12783159/...aster.zip.html |
Error in VBA Coding in Macro
Scroll down, hit the FREE button, type in the three letter
authorization code, and hit download if you wish to download the files. |
All times are GMT +1. The time now is 02:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com