Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
it can't compile, It appears to be the ws as object declaration. How do I
declare ws? tnx, Private Sub UserForm_Initialize() Dim intLastRow As Integer Dim ws As Object Dim c As Range Dim rng As Range Set ws = ThisWorkbook.Worksheets("patients") intLastRow = ws.Cells.SpecialCells(xlCellTypeLastCell).Row 'intLastRow = Cells.Find(What:="*", After:=[A1], SearchDirection:=xlPrevious) Set rng = ws.Range("A1:A" & intLastRow) ComboBox2.Clear For Each c In Worksheets("patients").rng ComboBox2.AddItem c.Value Next c End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA error: "object doesn't support this property or method" | Excel Discussion (Misc queries) | |||
object reference does not support this property or method | Excel Discussion (Misc queries) | |||
ddm enable/disable: Object doesn't support this property, my a** it doesn't | Excel Discussion (Misc queries) | |||
runtime error 1004 method range of object '_global failed | Excel Discussion (Misc queries) | |||
Object doesn't support this property or method (Error 438) | Excel Discussion (Misc queries) |