Results 1 to 3 of 3

REALLY Basic question on variable syntax...

Threaded View

  1. #1
    Registered User
    Join Date
    09-27-2012
    Location
    Monticello, Florida
    MS-Off Ver
    Excel 2010
    Posts
    12

    Angry REALLY Basic question on variable syntax...

    Obviously I'm a newbie, so I'd appreciate learning how I'm messing up this code:

    Sub Macro4()
    '
    ' Macro4 Macro
    '
    
    '
     Dim myRow As Long
    
        Range("C2").Select
        Selection.End(xlDown).Select
        Selection.Offset(1, 0).Select
        myRow = ActiveCell.Row
        Rows("myRow:201").Select
    
        
        
    End Sub
    I'm simply trying to delete anything in the rows from the end of my last data through row 201. I keep getting a Type mismatch error on the last row. I assume I'm not entering the variable myRow correctly - maybe I'm missing some apostrophy's or quotation marks???

    Man I hate being dumb at something!

    Thanks in advance!

    Mike
    Last edited by Accountant II; 09-27-2012 at 04:36 PM. Reason: Entered code tags

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1