Many thanks Vabz.
I've got it working. The problem was that I had formula in the 'blank'
cells.
I've now restricted the list to cells containing values which works.
Thanks again.
On Wednesday, 24 December 2014 11:45:04 UTC, Eddie wrote:
> Hi,
> I'd like to use
The original array formula doesn't work for me with numbers. it only lists
the lowest value in the returned list. :(
On Wednesday, 24 December 2014 11:45:04 UTC, Eddie wrote:
>
> Hi,
> I'd like to use the following array formula to sort numerical values
> rather than te
Hi,
I'd like to use the following array formula to sort numerical values rather
than text. Is anybody able to convert it for me?
=INDEX(tbl, SMALL(IF(SMALL(IF(COUNTIF($B$7:B7, tbl)+ISBLANK(tbl)=0,
COUNTIF(tbl, "<"&tbl)+1, ""), 1)=IF(ISBLANK(tbl), "", COUNTIF(tbl,
"<"&tbl)+1), ROW(tbl)-MIN(ROW(t
a1:b10
> 3. RefCell is asking for a cell such as b12
> Hope this helps
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
> -Original Message-
> From: Eddie
> Sent: Monday, January 09, 2012 6:54 AM
> To: MS EXCEL AND VBA MACROS
> Subj
How do I get this UDF to function correctly? I keep getting #name? in
the destination cell.
Thanks in advance.
Ed.
' This User Defined Function can be called to calculate which Decile a
single cell
' falls within a larger range of cells
Public Function DECILE_RANK(DataRange, RefCell)
'DECILE_R
I've sorted it! It was because the dates were displayed in date format
rather than numbers!
Thanks very much for all your help.
Ed.
On Nov 4, 2:43 pm, Eddie wrote:
> The tab colour doesnt change if the date is within the range or not.
> Either way the tab remains yellow.
>
>
e
> > End Sub
>
> > Paul
> > -
> > “Do all the good you can,
> > By all the means you can,
> > In all the ways you can,
> > In all the places you can,
> > At all the times you can,
> > To all the people you can,
> > As long as ever you can.” - John Wesley
> > --
--
> “Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> -
>
> __
Private Sub Worksheet_Change(ByVal Target As Range)
Sheets("1").Select
If Range("f41").Value = Range("g41:g68") Then
ActiveWorkbook.Sheets("1").Tab.ColorIndex = 5
Else
ActiveWorkbook.Sheets("1").Tab.ColorIndex = 6
End If
End Sub
Hi,
Using the above code I'm trying to colour worksheet tabs, dete
ctivesheet.Range("f" &
> Selection.Row)
>
> End Sub
>
> Sam
>
>
>
>
>
> On Thu, Nov 3, 2011 at 10:54 PM, Eddie wrote:
> > Yes, works great on sheet1 but doesnt work on others...
>
> > On Nov 3, 5:21 pm, Sam Mathai Chacko wrote:
> >
;
> End Sub
>
> Sam
>
>
>
>
>
> On Thu, Nov 3, 2011 at 10:16 PM, Eddie wrote:
> > This looks good but gettin a run time error 1004!
>
> > On Nov 3, 4:36 pm, "dguillett1" wrote:
> > > Sub cc()
> > > Sheets("start").
Sheet1").Range("f" &
> Selection.Row)
>
> End Sub
>
> Regards,
>
> Sam Mathai Chacko
>
> On Thu, Nov 3, 2011 at 9:25 PM, Eddie wrote:
>
> Sub PasteStat()
>
> Sheets("start").Select
> Range("h6:l6").Select
Thanks,
However, can you automate this so I dont have to edit the sheet number
everytime i use a differnt sheet?
On Nov 3, 4:17 pm, ashish koul wrote:
> replace sheet1 with ur Sheet30 in the ur code like
>
> Sheets("Sheet30").Select
>
>
>
>
>
> On Thu,
Sub PasteStat()
Sheets("start").Select
Range("h6:l6").Select
Selection.Copy
Sheets("Sheet1").Select
Range("f" & Selection.Row).Select
ActiveSheet.Paste
End Sub
Hi,
How do I edit the above so that the selected sheet (in this case
"Sheet1") is the active sheet. I.e. if i
Hi,
I have a workbook with around 100 worksheets. The first sheet acts as
a summary/introductory or front end and has links to other "sub-
sheets". In the first sub-sheet I've created a button containing a
macro that returns you to the introduction sheet. What I'd like to do
is copy this button on
15 matches
Mail list logo
