Search:

Type: Posts; User: j4ymf; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    1
    Views
    145

    Help creating a graph

    Hello

    I need help creating a graph, I have a photo of what I need - what is the best way to display a photo on the forum?

    Thanks Jay
  2. Thread: Help with VBA

    by j4ymf
    Replies
    1
    Views
    134

    Help with VBA

    Hello Folks

    Ive had help to get as far as I have from people on this forum, thank you. but I'm after a little more help please.
    the code does what I need it to I just need a little tweak.

    it...
  3. Replies
    1
    Views
    84

    Macro to disabe a macro

    Hello

    Can I have a macro to disable another macro

    Thanks Jason
  4. Thread: Adapt some VBA

    by j4ymf
    Replies
    8
    Views
    250

    Re: Adapt some VBA

    whoooooo

    Thank you, just what I needed
  5. Thread: Adapt some VBA

    by j4ymf
    Replies
    8
    Views
    250

    Re: Adapt some VBA

    hello mohadin

    thank you but its still this line what not doing what I need
    Cells.Interior.ColorIndex = 0
    its chancing the whole sheet white and I only need it to change A12:AE39 white

    ...
  6. Thread: Adapt some VBA

    by j4ymf
    Replies
    8
    Views
    250

    Re: Adapt some VBA

    Good Morning mohadin

    thanks for the code

    it works good but what im after is for the code to only change the background colour to white
    Cells.Interior.ColorIndex = 0

    my code works more like...
  7. Thread: Adapt some VBA

    by j4ymf
    Replies
    8
    Views
    250

    Adapt some VBA

    hello I have found this code

    how do I change the code to only change the selected cells to turn white
    Cells.Interior.ColorIndex = 0

    Cells(A12:AE39).Interior.ColorIndex = 0
    I only want it to...
  8. change row colour when cell is selected for ease

    Hello

    I have a sheet but in struggling to see if I'm on the correct row when im filling it in
    Can you change the row colour when a cell is selected?


    ie: if I select any thing between...
  9. Replies
    1
    Views
    129

    Rotate histogram graph

    Hello

    does anyone know how to rotate a histogram graph 90 deg

    Thank you
  10. Thread: Histogram graph

    by j4ymf
    Replies
    1
    Views
    116

    Re: Histogram graph

    Hello I have an histogram graph

    how do I rotate it 90 deg
  11. Thread: Histogram graph

    by j4ymf
    Replies
    1
    Views
    116

    Histogram graph

    Hello We use a product that generates an histogram on a PDF

    I would like to generate a mirror image of the report but I also need help to generate an histogram graph.

    How can I show you how the...
  12. Thread: line graph

    by j4ymf
    Replies
    2
    Views
    95

    Re: line graph

    Thank you Jon Peltier, your a star
  13. Thread: line graph

    by j4ymf
    Replies
    2
    Views
    95

    line graph

    Hello All

    I was wondering how do I change the dot size (plot points) on a line graph
    Mine are too big

    Thank you Jason
  14. Thread: IsBlank

    by j4ymf
    Replies
    2
    Views
    149

    Re: IsBlank

    Thank you rick
  15. Thread: IsBlank

    by j4ymf
    Replies
    2
    Views
    149

    IsBlank

    hello

    I have this formula
    =INDEX(Holidays!$A$4:$OE$92,MATCH(O66,Holidays!$A$4:$A$92,0),MATCH($Q$54,Holidays!$A$3:$OE$3,0))

    I need to include if O66 is blank, how would I do that

    than you...
  16. Thread: VBA Macro

    by j4ymf
    Replies
    3
    Views
    148

    Re: VBA Macro

    sorry my fault

    I have dates in A5:AAA5
    and I have =TODAY() in A1, how do I find the same date in the range and jump to that.

    Does that make sense

    Jay
  17. Thread: VBA Macro

    by j4ymf
    Replies
    3
    Views
    148

    VBA Macro

    Hello if I use this macro it takes me to GP3
    in cell A1 I have =TODAY(), how do I jump to the cell that has todays date in?

    <code>Sub Jumpto()

    Range("GP3").Select
    End Sub</code>

    Thank...
  18. Thread: Countif

    by j4ymf
    Replies
    2
    Views
    138

    Re: Countif

    Great thank you
  19. Thread: Countif

    by j4ymf
    Replies
    2
    Views
    138

    Countif

    Good Morning
    how do I count my range is the same but my result is H or T?


    =COUNTIF(Q38:Q48,"H")

    Thank you
  20. Thread: Index Match

    by j4ymf
    Replies
    3
    Views
    149

    Re: Index Match

    BISH BASH BOSH
    thank you
    you are a star
  21. Thread: Index Match

    by j4ymf
    Replies
    3
    Views
    149

    Index Match

    Hello
    if I can find the ROWS and COLUMNS using MATCH how do I find out what is in the range


    <code>=MATCH($O$38,Holidays!$A$4:$A$92,0)</code> returns the row number. result=19...
  22. Replies
    16
    Views
    247

    Re: formula from a date in a different cell

    thank you Fluff, that's fantastic
  23. Replies
    3
    Views
    158

    Re: Change all cells to Absolute $?$

    Thank you
  24. Replies
    3
    Views
    158

    Change all cells to Absolute $?$

    Hello
    Is there a way where you can change all the cells to absolute references?

    I want to select A1:OO100 and change all the formula to $?$ what is the short cut to do this?
    im using a Mac.
    ...
  25. Replies
    16
    Views
    247

    Re: formula from a date in a different cell

    Hello All
    I was given this formula from Joe4 and it works fantastic and now I need to add a bit too it.
    =IF(AND(AA6 >= $F$23, AA6 < $G$23),$I$23,"")

    currently its looking between two dates but...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4