| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I know this is simple but ans= and nothing happens
I know this is something really simple that I am simply missing but I
have the brain cramps. Sorry. Select Case ans Case "7", "6", "5", "4", "3", "2" ans = (O40) Case 1 Sheets("DISTRICT ROLL-UP").Select Range("O40").Select ActiveCell.FormulaR1C1 = "7" Sheets("DISTRICT ROLL-UP").Select Range("B31:I34").Select Selection.Copy Sheets("DAILY").Select Range("C137").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Select Cell O40 is 7 and nothing is happening. The data in cells B31;I34 is not copying and pasting. What am I missing? Don |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I know this is simple but ans= and nothing happens
I would guess that you are putting quotes around numbers which are making
them text values. Try using Case 7, 6, 5, 4, 3, 2 without the quotes " wrote: I know this is something really simple that I am simply missing but I have the brain cramps. Sorry. Select Case ans Case "7", "6", "5", "4", "3", "2" ans = (O40) Case 1 Sheets("DISTRICT ROLL-UP").Select Range("O40").Select ActiveCell.FormulaR1C1 = "7" Sheets("DISTRICT ROLL-UP").Select Range("B31:I34").Select Selection.Copy Sheets("DAILY").Select Range("C137").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Select Cell O40 is 7 and nothing is happening. The data in cells B31;I34 is not copying and pasting. What am I missing? Don |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
| Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
| Simple lookup - or maybe not so simple - help! | Excel Worksheet Functions | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
| Make it more simple or intuitive to do simple things | Charts and Charting in Excel | |||
Linear Mode
