Assiging value to range through input box

Karthik

Guest

Posts: n/a

6th Dec 2006

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

« Select page tab when form opens | Calendar change month from multiple sheets to one sheet, Excel 2000 & 2003 »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
i want to input data into a range from a simple input location	joemassillon	Microsoft Excel Programming	0	6th Mar 2010 02:17 AM
i want to input data into a range from a simple input location	joemassillon	Microsoft Excel Programming	1	5th Mar 2010 03:37 PM
Resize Table Range to exclude zero values and Input New Range into achart object	jparnold	Microsoft Excel Programming	10	22nd Dec 2009 04:09 PM
Input mask date syntax-limit input to a number range	=?Utf-8?B?QmlsbGlhbQ==?=	Microsoft Access Database Table Design	2	18th Nov 2007 03:37 PM
CODE to select range based on User Input or Value of Input Field	Sandi Gauthier	Microsoft Excel Programming	4	8th Dec 2003 03:22 PM