LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default application-defined or object defined error

here's my code

If Worksheets("selector").Range("b5").Value2 = "" Then
Set startrange = Range("b5")
ElseIf Worksheets("selector").Range("b6").Value2 = "" Then
Set startrange = Range("b6")
ElseIf Worksheets("selector").Range("b7").Value2 = "" Then
Set startrange = Range("b7")
ElseIf Worksheets("selector").Range("b8").Value2 = "" Then
Set startrange = Range("b8")
ElseIf Worksheets("selector").Range("b9").Value2 = "" Then
Set startrange = Range("b9")
ElseIf Worksheets("selector").Range("b10").Value2 = "" Then
Set startrange = Range("b10")
ElseIf Worksheets("selector").Range("b11").Value2 = "" Then
Set startrange = Range("b11")
ElseIf Worksheets("selector").Range("b12").Value2 = "" Then
Set startrange = Range("b12")
ElseIf Worksheets("selector").Range("b13").Value2 = "" Then
Set startrange = Range("b13")
ElseIf Worksheets("selector").Range("b14").Value2 = "" Then
Set startrange = Range("b14")
ElseIf Worksheets("selector").Range("b15").Value2 = "" Then
Set startrange = Range("b15")
Else: info = MsgBox("Sorry, you may only enter 10 songs at a time!",
vbOKOnly, "Maximum Songs Input")
End If
snginp = MsgBox("Please verify " + song + " " + folder + " " + volume + "
" + disk + " " + num, vbYesNo, "Verify Input")
If snginp = vbYes Then
**** Worksheets("selector").Range(startrange).Value2 = song ****
nextrange = startrange.Offset(rowoffset:=0, columnoffset:=1)
Worksheets("selector").Range(nexttrange).Value2 = folder
nextrange = nextrange.Offset(rowoffset:=0, columnoffset:=1)
Worksheets("selector").Range(nextrange).Value2 = volume
nextrange = nextrange.Offset(rowoffset:=0, columnoffset:=1)
Worksheets("selector").Range(nextrange).Value2 = disk
nextrange = nextrange.Offset(rowoffset:=0, columnoffset:=1)
Worksheets("selector").Range(nextrange).Value2 = num


Error occurs at the line enclosed in **** ****

I need my input to be based on the first blank cell in a range.

Any suggestions?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export a chart in a GIF file. Run-time error '1004': Application-defined or object-defined error; [email protected] Excel Programming 4 September 16th 07 11:09 PM
Application-Defined or object defined error 1004 When ran on exel97 but not 2003 bornweb Excel Programming 0 February 17th 07 11:30 PM
Copying A Range of Cells From one Sheet to Another - Error Application Defined or Object Defined Matt[_39_] Excel Programming 3 July 25th 06 01:13 AM
Runtime error 1004- application defined or object defined erro Novice Excel Programming 0 February 6th 06 09:34 PM
Runtime error 1004- application defined or object defined erro Novice Excel Programming 1 February 6th 06 09:33 PM


All times are GMT +1. The time now is 11:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"