Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MyRow error
Can anyone see a problem with this: Code: -------------------- Sheets("Sheet1").Activate Set MySheet = ActiveSheet MyRow = Sheets("Sheet1").Range("O1") Claimno = Range(MyRow, 11) -------------------- It keeps erroring on the last line. I'm trying to get it to find the last value entered on spreadsheet. Range O1 shows the Row to look for and is correctly showing the Row to be used. thanks -- rocket0612 ------------------------------------------------------------------------ rocket0612's Profile: http://www.excelforum.com/member.php...o&userid=19492 View this thread: http://www.excelforum.com/showthread...hreadid=380551 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Error of slope taking into account error of the data points | Excel Worksheet Functions | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
Automation Error, Unknown Error. Error value - 440 | Excel Programming |