Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Extract all values (from list) that lie within a range

    Thankyou, so much, that worked brilliantly.

    Now, all I need to do is dissect your formula to see why it works.

    Again, thankyou, so much.

    Kind regards,

    Chris
  2. Extract all values (from list) that lie within a range

    Is there a way to extract all numbers from a list that lie within a range ?

    For example, I have a list of ascending numbers in the range B3:N3 and two numbers in P3 and R3 .. the number in P3 is...
  3. Re: first number (in a list) larger than a certain value

    Thankyou, so much, to both of you, they both worked brilliantly.

    I've gone with Tetra's formula, but am happy to switch if my next query requires me to ...

    I still have that list range in...
  4. first number (in a list) larger than a certain value

    I have a list in the range ... CM37:CW37

    I have a value in ... BY37

    I'd like to find the first number in the list range that is larger than the value in BY37.

    eg: List Range in CM37:CW37...
  5. Replies
    2
    Views
    219

    convert row list to table

    I have a list of values in the column range C32 to C800.

    I have a formula I use to convert a the column list to a table just 10 columns wide starting in cell L32 ...
    ...
  6. Replies
    4
    Views
    212

    Re: countif within range

    Thanks Michael,

    i just suddenly realised i probably should be using countifs, not countif.

    Very kind regards,

    Chris
  7. Replies
    4
    Views
    212

    countif within range

    I have a row of data in the range L5:BI5

    In CA5 I have a number

    In BX5 I have another number

    I'd like to count how many values in the initial range L5:BI5 exist between the lower value found...
  8. Replies
    2
    Views
    157

    Excel Chart query

    I have a 'Line with Markers' chart plotting the data range ... 'View Individual Student Profile'!$D$56:$E$68

    I've removed the line, so all I have is thick, black dot markers for each of the 13...
  9. force PDF save to be at top of page ???

    I'm using the following code to save any worksheet (named with a 5-digit code) as a PDF in a given location ..


    Dim wPath As String, r1 As String, r2 As String, r3 As String
    wPath =...
  10. Replies
    2
    Views
    184

    Re: Dim ws As Worksheet issue

    Hi Alan,

    I've just figured out my issue ... was a very simple fix.

    Ta for looking into it.

    Kind regards,

    Chris
  11. Replies
    2
    Views
    184

    Dim ws As Worksheet issue

    I'm receiving an error message ... (Compile error: Duplicate declaration in current scope) ... when I run some code that has 13 components, but I believe it's the following two components that...
  12. Re: Save certain worksheets as PDFs in a fluid location

    Strike that ... everything you wrote works perfectly. I was doing something wrong at my end.

    Thankyou again so much for doing that.

    It is very much appreciated.

    Very kind regards,

    Chris
  13. Save certain worksheets as PDFs in a fluid location

    I currently use the following code to print all worksheets named with a 5-digit name (eg: 34716)


    For Each ws In ThisWorkbook.Worksheets If ws.Name Like "#####" Then
    ...
  14. Re: code to save sheets as separate word files

    I can no longer see my thread in the posts ... have you removed my thread from public view ?

    Kind regards,

    Chris
  15. Re: code to save sheets as separate word files

    Hi Macropod, I'm actually quite insulted by your terse reply.

    If you look back through my history, in both this username, and the one I used many years ago (closer to 2002) you will find that I...
  16. Re: code to save sheets as separate word files

    Hi Macropod, as I mentioned, I've inherited this spreadsheet, and am unfamiliar with vba coding.

    Kind regards,

    Chris
  17. Re: code to save sheets as separate word files

    if it's simple to go to PDF, can we code it that way please ?

    I appreciate any assistance at all,

    very kind regards,

    Chris
  18. code to save sheets as separate word files

    I have inherited a spreadsheet which has a number of userforms that have some reasonable coding in behind them.

    One userform allows the user to click on which teacher they are, and the userform...
  19. Replies
    2
    Views
    150

    Re: first 6 unique numbers in row

    of course, embarrassed i missed it.

    Thankyou for solving that,

    Kind regards,

    Chris
  20. Replies
    2
    Views
    150

    first 6 unique numbers in row

    Hi,

    I have the following numbers in range AS133:BD133 ...
    <tbody>
    10
    23
    2
    2
    23
    97
  21. Re: vba to screen-shot a given range on every worksheet in file

    Hi again Kenneth, I ran your #6 post and it works brilliantly, I am so thankful to you.

    However, since writing my initial post, I've increased the size of what I need imaged from the range...
  22. Re: vba to screen-shot a given range on every worksheet in file

    Thanks Kenneth, I'll definitely try them out.

    Thankyou, so much, again, for all your work.

    Very kind regards,

    Chris
  23. Re: vba to screen-shot a given range on every worksheet in file

    Thankyou all for your contribution to this ... I have to say I didn't understand a single word of any of it.

    I'll have my IT guys at work run their eyes over what you've all said, but I suspect...
  24. vba to screen-shot a given range on every worksheet in file

    Is it possible to have code that takes a screen-shot of all sheets named with a 5-digit student ID number (eg: 69213) and save that image as a jpeg (named with the same 5-digit code as the sheet the...
  25. Re: create new sheets based on list of student ID numbers

    that worked perfectly ... thankyou to everyone who helped me,

    kind regards,

    Chris
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4