dave_yd New Member May 30, 2014 #1 Dear All expert, I want to save my input sheet into my database, but ihave problem while execute my macro which assigned to blue arrow. Please help me to solve. The problem is inthe attached files. Regards David Attachments Bank Data Final Macro ask.xlsm 752 KB · Views: 6
Dear All expert, I want to save my input sheet into my database, but ihave problem while execute my macro which assigned to blue arrow. Please help me to solve. The problem is inthe attached files. Regards David
N NARAYANK991 Excel Ninja May 30, 2014 #2 Hi David , You can use either of the following statements instead of the one you have in place at present : If Finddate <> 0 Then or If QSInput.Range("C3").Value <> "" Then But even if you do this , the code errors out at the following line : SRDb.Range("A" & BrsAkhir).Value = BrsAkhir - 1 where SRDb is not defined. You need to correct this. Narayan
Hi David , You can use either of the following statements instead of the one you have in place at present : If Finddate <> 0 Then or If QSInput.Range("C3").Value <> "" Then But even if you do this , the code errors out at the following line : SRDb.Range("A" & BrsAkhir).Value = BrsAkhir - 1 where SRDb is not defined. You need to correct this. Narayan
