Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Msgbox and variants - a deadly combination
Dear
I am attempting to show cells A1 to B4 in a msgbox. The code I had tried is: dim c1(6) as integer dim c5 as variant c1(6) = Selection.CurrentRegion.Rows.Count c5 = (Range("A1:B" & (c1(6)))) MsgBox c5 However, this is not working. Any ideas? Thanks, Peter |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Msgbox and variants - a deadly combination
Thanks for that.
Only one problem, that creates a msgbox for each cell. Is there any way to have all the information in one msgbox? Peter On 24 Jan, 14:28, Gary''s Student wrote: Sub peter() Set r = Range("A1:B4") For Each rr In r MsgBox (rr.Value) Next End Sub This will show cells A1 to B4 in a messagebox -- Gary''s Student gsnu200702 "Peter" wrote: Dear I am attempting to show cells A1 to B4 in a msgbox. The code I had tried is: dim c1(6) as integer dim c5 as variant c1(6) = Selection.CurrentRegion.Rows.Count c5 = (Range("A1:B" & (c1(6)))) MsgBox c5 However, this is not working. Any ideas? Thanks, Peter- Hide quoted text -- Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combination | Excel Discussion (Misc queries) | |||
mismatch error and Variants | Excel Programming | |||
can I set row/column label as variants? | Excel Programming | |||
Variants vs ranges | Excel Programming | |||
Array Parameters as Variants Only | Excel Programming |