subscript out of range

Hot Topic

MS Office document and image writer print driver
VB to MSWORD BookMark
Excel FTP using msinet.ocx - PROBLEM
Excel Time Help
Comparing and filtering data in Excel?
Control Break Trap will not work whilst Userform is displayed
Run Time Error 9 when Calling a Userform
MS Office document and image writer print driver
I have a fairly simple macro writing question (in Word).
Memory profilers

Microsoft ISV

Input from user form put into specified cell.
Hide/unhide
How to create a menu & submenu ?
find current path in VBA macro word
How do connect an Excel file from Remote Server
Digital Certificate Error
Adding a command button to the toolbar or menu bar in Excel?
WebPart Problem (?) / BSM2005
open a workbook with events turned off
bracketing "ifs" and "ands" and "ors" in VBA over Excel

subscript out of range

I am getting an error when running the script

Do While (Not (Workbooks(bookmonth).Worksheets("by associate").Cells(4, i) = "dsl") Or Not (Workbooks(bookmonth).Worksheets("by associate").Cells(4, i) = "hsi"))

I am uncertain why this is coming up. i is currently set to 1, so it should be starting to search in cell a1.




Answer this question

subscript out of range

  • mido1971

    I can not see anything wrong with the code that would produce a type mismatch on that line.

    Any value contained in the cell A4 would be compared to the two string values and would either proceed into the loop or pass over it.

    What value do you have in the cell when the test raises the error


  • W.Yuan

    thank you, there was an error in my code and it was not populating bookmonth correctly, however, I am now getting a type mismatch. How do I correct for this

  • MA2005

    yes. and it is plain text in the field i am pulling from

  • etones

    Is the type mismatch on that same line of code


  • pgems

    Hi,

    If i is currently 1 then are the other indexes correct

    What's in the variable bookmonth
    Is the sheetname really "by associate". Perhaps there is a extra space somewhere.

  • subscript out of range
Answer this question