Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am getting a VB '400' error on (the red circle with an X and only the 400)
on the following this is all the code that is in the sub: <BEGIN VB CODE Private Sub AddToSalesJournal() Sheets("sales journal").Select Cells(Cells.Rows.Count, 4).End(xlUp)(2).Select End Sub <END VB CODE the next line that is excecuted after this sub exits is MsgBox "Order # " & workOrderNumber & " for " & customerName & " added successfully." and the code is done running (or should be). Is there a problem with my system? Or am I doing something wrong? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) | |||
"FIND" generates "Type mismatch" error | Excel Programming | |||
Problem with "On error resume next" with "custom VLookup" | Excel Programming | |||
Getting "compile error" "method or data member not found" on reinstall | Excel Programming |