Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sub Main()
Dim sStr as String sStr = "A1:B30" mysub sStr End Sub Sub MySub(sStr1 as String) msgbox Range(sStr1).Address(External:=True) End Sub -- Regards, Tom Ogilvy "John Kauffman" wrote in message ... Using VBA, I want to collect a range from the user with a UserForm, and then pass the range string to a subroutine in a module. I can pass numbers in this fashion, but I am unsuccessful passing strings. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Passing array of strings from DLL function to VBA | Excel Programming | |||
passing strings | Excel Programming | |||
passing strings | Excel Programming | |||
Passing variables from module to userform | Excel Programming | |||
passing strings | Excel Programming |