| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Before I lose any more hair: Run-time error '9'
I've been using the following code in a workbook successfully:
Public Sub SMCMonthlyUpdateSFR() Sheets("work").Select Range("C3").Select Dim Cell As Range For Each Cell In Range("B3:B27") City = Cell.Value Call copy Next End Sub Public Sub copy() Selection.copy Sheets(City).Select I copied the code to another workbook with the same format, different data, and now the City value is not being posted to Sheets(City).Select. Can anyone tell me what the problem is? TIA Rick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
| please help me keep my hair....... | Excel Discussion (Misc queries) | |||
| run-time error '91'-Close Button error | Excel Discussion (Misc queries) | |||
| Run time error 1004, General ODBC error | New Users to Excel | |||
| Please help me, losing hair (chart with 2 data against time) | Charts and Charting in Excel | |||
Threaded Mode
