Posted to microsoft.public.excel.programming

Need Help Fast![_2_] Need Help Fast![_2_] is offline

external usenet poster

Posts: 25

Defining a range in vba???? Please help

I have multiple ranges in a spreadsheet. The problem is I want to define
them, and use them in a function in vba. I do not want the cells that are
zero or smaller to be included in the range when the range is being used in
the function. I was wondering if it is possible to say like if range(A1:B200)
0 then range(A1:B200) = rngtemp. Can someone help? Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Defining series range for named range	Barb Reinhardt	Excel Programming	1	August 3rd 06 09:00 PM
defining a range	Stefi	Excel Programming	2	July 20th 06 09:18 AM
Defining a range for a look up	MH UK	Excel Programming	5	February 16th 06 03:11 PM
Defining a Range	Ric[_5_]	Excel Programming	4	April 26th 04 07:34 PM
Defining a range	Matt	Excel Programming	3	January 23rd 04 03:21 PM

All times are GMT +1. The time now is 11:27 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us