Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox including range value
I've played around with this, and looked at other posts. Still can't
get this right. I want to show a MsgBox with a message & also the value of a range. Here's what I've got so far. Any help would be appreciated. I'm getting a 1004 error. Method 'range of object'_Global' failed. I've tried variations of this: MsgBox "Miles remaining until next oil change: " & Range (NextOilChg_Chev).Value Note: This is all in 1 line in the module. Thanks j.o. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Including in a range | Excel Discussion (Misc queries) | |||
Copy Range including Formats and Forumulas | Excel Programming | |||
multiple lookup including date range | Excel Worksheet Functions | |||
MAX/MIN in range potantially including text | Excel Worksheet Functions | |||
Average range including blank cells: #DIV/0! | Excel Worksheet Functions |