Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assiging value to range through input box
hi
I want to know how to assign value to range through input box in the following query instead of declaring the range in the query itself. Sub sumbolded() For Each c In Range("b1:b22") If c.Font.Bold = True Then ms = ms + c Next c MsgBox ms End Sub Thanks In Advance!!! Regards, Karthik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List Box - For Input Range can I use named range in another workbo | Excel Worksheet Functions | |||
assiging categories | Excel Worksheet Functions | |||
Input box range - output range | Excel Programming | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
Macro to input formula in range based on another range | Excel Programming |