Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Run-Time Error '1004' ??????
Glenn, Thank you my column index number was zero. I assumed you started with zero when counting columns. Thanks for your help. Everything works as expected now. Also MakeItSo, I am using an English Excel. Thanks for everyone's input.- spewbanks
- Post #9
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Run-Time Error '1004' ??????
Hi all, thanks for the replies. I changed all my variables to Long just in case, with no change. Here is the code that debug highlights right before I get the error: If Sheet1.TextBox1.Text = Sheet3.Cells(lngRowNum, lngColNum).Value Then Thanks for all your help.- spewbanks
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Run-Time Error '1004' ??????
I am in the beginning stages of coding together an excel project to search and find specific data. I introduced my first WHILE statement and now I get a message box that says: "RUN-TIME Error '1004' Application-Defined or Object-Defined Error" Here is my code: Private Sub...- spewbanks
- Thread
- Replies: 8
- Forum: VBA Visual Basic for Applications (Microsoft)
