Search:

Type: Posts; User: pp2014; Keyword(s):

Search: Search took 0.01 seconds.

  1. It worked !! Thanks a lot for the help....

    It worked !! Thanks a lot for the help....
  2. I changed my code to following: everything works...

    I changed my code to following: everything works fine but I get error on I get the I get "Run-time error '9': Subscript out of range on the line below:
    Sheets("List").Copy...
  3. Steve, I changed to the following: It works...

    Steve,

    I changed to the following: It works but it prompts whether to delete or cancel.

    Workbooks(Dfname).Sheets("List").Delete

    I get the message "Data may exist in the sheet selected for...
  4. VBA Code is in another workbook named test.xlsm. ...

    VBA Code is in another workbook named test.xlsm.
    I am getting Run-time error '9' Subscript out of range at the following line ( I commented the line above which was also giving me the same error)...
  5. VBA code for copying Sheet from One workbook to Another workbook

    Hi,
    I am new to VBA. I want to copy a sheet from one workbook to another workbook. I have following VBA code. I am getting "Run-time error '9': Subscript out of range. Please help.


    Sub...
  6. I am sorry below is the code: Sub Copy_sh()...

    I am sorry below is the code:


    Sub Copy_sh()
    Dim SDrv As String
    Dim DDrv As String
    Dim Sfname As String
    Dim Dfname As String

    SDrv = "Y:\Main\"
  7. Help with Copying Sheet from One Workbook to Another Workbook using Excel VBA

    I am new to VBA. I have folllowing code I am trying to use to copy the Sheet from One to Another but I get error "Run-time error '9': Subscript out of range.

    Sub Copy_sh()
    Dim SDrv As String...
Results 1 to 7 of 7