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!

Search results for query: *

  • Users: Adker
  • Order by date
  1. Adker

    Object Variable or With Block Variable no set - EXCEL

    Geoff, Thanks very much for your help. Your solution works as well. I am including a section of the code to share with others your fix. Worksheets("Charts & Graphs").Activate startDate = Range("C33") If startDate = "" Then End startDate = Format(startDate...
  2. Adker

    Object Variable or With Block Variable no set - EXCEL

    Finally something that works on all platforms attempted! Set fCell = Selection.Find(What:=DateValue(startDate), _ LookIn:=xlFormulas, LookAt:=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext) startColumn = fCell.Column I found this solution at...
  3. Adker

    Object Variable or With Block Variable no set - EXCEL

    Here is the latest sub with changes made to reflect suggestions here. That last thing I did was to add the format lines for the start and stop dates. Again it works fine with the exception of Excel97 on WinNT. Other platforms tested are Excel2000 on Win2000 and Excel97 on Win98. Private Sub...
  4. Adker

    Object Variable or With Block Variable no set - EXCEL

    Still no go. Near as I can tell all the requirements listed above are satisfied. Frustrating because it runs on all platforms except the one used by most of the users on this intranet(NT & Ecxcel97). Perhaps there is a better way of doing what I am attempting. I have a dynamic range of...
  5. Adker

    Object Variable or With Block Variable no set - EXCEL

    Same error. Object Variable or With Block Variable no set.
  6. Adker

    Object Variable or With Block Variable no set - EXCEL

    I spoke too soon. This still does not work in Excel 97 running on WinNT. Other platforms are fine. Private Sub CommandButton1_Click() On Error GoTo errorHandler Dim startDate As String Dim stopDate As String Dim startColumn As Integer Dim stopColumn As Integer Dim StartCol As String Dim StopCol...
  7. Adker

    Object Variable or With Block Variable no set - EXCEL

    startColumn = Selection.Find(What:=startDate, _ LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext).Column Sorry, I should have included this in the initial post.
  8. Adker

    Object Variable or With Block Variable no set - EXCEL

    Private Sub CommandButton1_Click() On Error GoTo errorHandler Dim startDate As String Dim stopDate As String Dim startColumn As Integer Dim stopColumn As Integer Dim StartCol As String Dim StopCol As String MsgBox Application.Version Worksheets("Charts & Graphs").Activate startDate...

Part and Inventory Search

Back
Top