srizki
Well-known Member
- Joined
- Jan 14, 2003
- Messages
- 1,857
- Office Version
- 365
- Platform
- Windows
I use a spreadsheet to upload data on Oracle using Add-Ins, but many times there are specific number of rows that are uploaded, let’s say I have 1200 rows to upload, and let's say 587 will upload, whatever I do.
The upload sheet has a macro, that says that upload the rows where there is a flag in column B, so after the rows uploaded (587 rows) the flag is disappeared, and flag stays on the rest of the rows that did not upload.
What could be the reason. What should I change in the VBA to upload all the rows. Also, if I add rows after first few top rows it works, meaning the last row let’s say 587 moves to further down, so if I add 100 rows the 587 will become 687.
Please advise.
The upload sheet has a macro, that says that upload the rows where there is a flag in column B, so after the rows uploaded (587 rows) the flag is disappeared, and flag stays on the rest of the rows that did not upload.
What could be the reason. What should I change in the VBA to upload all the rows. Also, if I add rows after first few top rows it works, meaning the last row let’s say 587 moves to further down, so if I add 100 rows the 587 will become 687.
Please advise.