the range
  Home FAQ Contact Sign in
Search only in:
balt.jobs
 
 Advanced search
MATCHING GROUPS



more...
Group Profile...
POPULAR GROUPS

more...
found 979826 articles for 0.547 sec
Re: difference between range.text and range.value     

Author: Chip Pearson
Date: Dec 26, 2008 23:50

Range.Value returns the underlying value of a cell, regardless of how that cell is formatted for output. Range.Text returns exactly what appears in the cell. For example, if A1 contains the number 987.1234 and is ... Farrow" <sean.farrow@seanfarrow.co.uk> wrote: Hi; could somebody please explain the difference between rang.text and range.value? When should I use both? Chers Sean.
Show full article (0.81Kb) · Show article thread
Advanced Filter using a range name as the criteria     

Author: Joe
Date: Dec 26, 2008 22:40

I am running a macro and want to select records from a database that are within a date range that the macro prompts for. So macro gets STARTDATE and ENDDATE and has stored them in a date formatted field. STARTDATE=1/3/2008 and ENDATE=1/5/2008 The database is Event Date Event Name 1/1/2008 Event 1 1/3/2008 Event 2 1/5/2008 Event 3 1/7/2008 Event 4 What is ...
Show full article (0.47Kb)
Re: difference between range.text and range.value     

Author: Jim Cone
Date: Dec 26, 2008 22:37

... cell except when it isn't. (.Formula and .Value2 are better choices sometimes) An example: the cell.Value is 1.23456 but the cell.Text is 1.23 because the cell is formatted as "0.00" -- Jim Cone Portland, Oregon USA "Sean Farrow" wrote in message Hi; could somebody please explain the difference between rang.text and range.value? When should I use both? Chers Sean.
Show full article (0.48Kb) · Show article thread
Re: difference between range.text and range.value     

Author: Rick Rothstein
Date: Dec 26, 2008 22:32

See the help file example for the Text property of the Range object (put text cursor on word Range, press F1, select Text from the Property drop down). -- Rick (MVP - Excel) "Sean Farrow" <sean.farrow@seanfarrow.co.uk> wrote in message news:eoGlx65ZJHA.4852@TK2MSFTNGP04.phx.gbl... Chers...
Show full article (0.59Kb) · Show article thread
difference between range.text and range.value     

Author: Sean Farrow
Date: Dec 26, 2008 21:55

Hi; could somebody please explain the difference between rang.text and range.value? When should I use both? Chers Sean.
Show full article (0.13Kb)
Re: Christmas -- Range Day coming up!     

Author: Gunner Asch
Date: Dec 26, 2008 21:19

...box of Hornady 325 gr .450 Marlin shells and M1895 to match. Wow. Felt like I was twelve. I'm going to the range sometime in the next week. I'm taking the extra heavy PAST shoulder pad and some new ear... in the state lottery. I hear the terminal ballistics are good enough for anything on the continent within range, maybe 150 yds. It's the initial ballistics I'm worried about. I'm...
Show full article (2.17Kb) · Show article thread
Re: Long range cordless phone     

Author: Robin
Date: Dec 26, 2008 21:15

... in message news:bc6dnYTnAeuEtsjUnZ2dnUVZ8uOdnZ2d@posted.plusnet... What are the long range cordless phone options? The only frequency allocations I can find for the UK are the two CT1 Extended Range frequency pairs at 47/77 MHz but I've never seen any phones for these, and it looks like they've been phased out now anyway. GSM is best for long range phones
Show full article (0.40Kb) · Show article thread
Long range cordless phone     

Author: Ben
Date: Dec 26, 2008 20:05

What are the long range cordless phone options? The only frequency allocations I can find for the UK are the two CT1 Extended Range frequency pairs at 47/77 MHz but I've never seen any phones for these, and it looks like they've been phased out now anyway.
Show full article (0.26Kb)
long range cordless options     

Author: Ben
Date: Dec 26, 2008 18:06

What are the options for long range cordless phones? The only frequency allocations I can find for the UK are the two CT1 Extended Range frequency pairs at 47/77 MHz but I've never seen any phones for these.
Show full article (0.21Kb)
Re: Code for dynamic range     

Author: Per Jessen
Date: Dec 26, 2008 09:57

Hi Barry Thanks for your reply. What is the list range which you want to loop through. Where do you want the output? --- Per On 26 Dec., 07:39, Barry Lennox <BarryLen...@discussions.microsoft.com> wrote: Thanks Guys This works. Next question how do I put a loop in so that it goes through the list and stops after the last (in this case first entry). At present I have to ...
Show full article (0.51Kb) · Show article thread
3 · 4 · 5 · 6 · 7 · 8 · 9 · 10 · 11 · next