onerror

I tried adding OnError on my current sub. I success adding it but it always shows the Error message even there is no error. How to add the OnError correctly? Public Sub Searcher() Dim wss As Integer wss = Application.InputBox("Please enter Sheet Number", "Sheet Select", Type:=1) With...

Hi! I have one master Excel (sheet "WP_Data") to which I import data (content from two separate cells and the Excel name) from tens of source-Excels. In each of these source-Excels I have sheet named "Workpaper_main", where I have a cell that is named as "WP_balance". I have the folder path on...

Hi All Can anyone suggest a simple line of code that will generate an error in order to test out a "On Error Goto" code? Thanks Tom

So I have a code that copies over data from other workbooks i wanted a button to do so thus I have a runallmacros command that my code is contained with there aren't always as many books to be copied as I put in the code so the code works perfectly but when it jumps to the next command and finds...

I am new to loops inside VBA. but I do understand the concept behind them. Situation: I have a list of folders: (will call this variable: foldername) c:\documents\FolderA c:\documents\FolderB c:\documents\FolderC every weekdday I save a folder inside each of the folders with the date as...