Welcome !
         

 ActiveCell error

Author Message
rbobcat1

  • Total Posts : 3
  • Scores: 0
  • Reward points : 0
  • Joined: 1/12/2017
  • Status: offline
ActiveCell error Thursday, January 12, 2017 3:54 AM (permalink)
0
Can anyone tell me why the below gives me an error
Run-time error '13': Type mismatch
when I debug it it highlights the below line;
ActiveCell.Offset(0, -1).Value = ActiveCell.Offset(-1, -1).Value +1
 
  

 
tried to add the code but can't figure out how
 
<message edited by rbobcat1 on Thursday, January 12, 2017 4:05 AM>
 
#1
    Online Bookmarks Sharing: Share/Bookmark

    Jump to:

    Current active users

    There are 0 members and 2 guests.

    Icon Legend and Permission

    • New Messages
    • No New Messages
    • Hot Topic w/ New Messages
    • Hot Topic w/o New Messages
    • Locked w/ New Messages
    • Locked w/o New Messages
    • Read Message
    • Post New Thread
    • Reply to message
    • Post New Poll
    • Submit Vote
    • Post reward post
    • Delete my own posts
    • Delete my own threads
    • Rate post

    2000-2017 ASPPlayground.NET Forum Version 3.9