Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Can I update a cell from date to general format and retain the date instead of being converted to a number?

    I want to update a column format to general instead of a date. Can I retain the date instead of the date being converted into a number?
  2. Replies
    4
    Views
    179

    Re: Uses for the range.find method

    Sorry to be a bit vague before AlphaFrog. I did want the bottom of the text row but that was to try and work out if I could use it to see if a image would fit in the space between the bottom of the...
  3. Replies
    31
    Views
    833

    Re: Measuring distances with vba

    I then press end and it inserts the image with left alignment and starting in row 7. This is right on top of my table.
  4. Replies
    31
    Views
    833

    Re: Measuring distances with vba

    I remember, with the code is post 13, if the references are changed, I get the error message "The item with the specified name wasn't found."
  5. Replies
    31
    Views
    833

    Re: Measuring distances with vba

    Please remind me what I was trying to achieve with post 13.
  6. Re: What is wrong with my select case statement

    Never mind, I got it working.
  7. What is wrong with my select case statement

    This is the start of my select case statement and it has an error and I can't figure out why, can someone help me please?


    Dim printWorksheet As Worksheet, logoShape As Shape, tempImageFile As...
  8. Replies
    3
    Views
    64

    Re: Carriage return of text in a footer

    I just found it, I used the first option. :)
  9. Replies
    3
    Views
    64

    Re: Carriage return of text in a footer

    Thanks Michael, I used the second option but it put an extra line between each line. How do I make it so there isn't a blank line between the lines?
  10. Re: VBA code to insert an image in the header

    Thanks for that Peter :)
  11. Replies
    3
    Views
    64

    Carriage return of text in a footer

    I have code that enters text in a footer, how do I force vba to enter a carriage return in the footer so the text is on more than 1 line?
  12. Replies
    31
    Views
    833

    Re: Measuring distances with vba

    In relation to post #23 Mike, the document will need to be printed to pdf. Once it is in pdf form, if the text box was near the bottom of the page, the image will be put inserted below the text box...
  13. Replies
    31
    Views
    833

    Re: Measuring distances with vba

    The name of the sheet that the picture needs to go on is sheet1 and the textbox is called TextBox4.
  14. Replies
    4
    Views
    179

    Re: Uses for the range.find method

    Thanks for that AlphaFrog.

    That gives me the row of the bottom of my text box. Is there a way to measure the distance between several rows below that point and the bottom of the page that is on...
  15. Replies
    31
    Views
    833

    Re: Measuring distances with vba

    Sorry Mike, I don't really follow your question.
  16. Replies
    31
    Views
    833

    Re: Measuring distances with vba

    This line is highlighted

    If img.Height > Rows(Worksheets("sheet2").HPageBreaks(1).Location.Row).Top - Sheets("sheet2").Shapes("TextBox4").Top + Sheets("sheet2").Shapes("TextBox4").Height Then
  17. Replies
    31
    Views
    833

    Re: Measuring distances with vba

    I changed the references (sheet2 and textbox 1) and it still says subscript out of range. It inserts the image at a fixed point, regardless of where the text box is. Are all the sheet2 references...
  18. Replies
    31
    Views
    833

    Re: Measuring distances with vba

    Thanks for this code, I will try it and let you know.
  19. Replies
    31
    Views
    833

    Re: Measuring distances with vba

    Although, the sheet that has the images is called sheet2.
  20. Replies
    31
    Views
    833

    Re: Measuring distances with vba

    Is called something else, I just called it sheet1 to desensitize it.
  21. VBA code to insert an image in the header

    I have 2 images stored on a sheet in my workbook. I need to be able to copy them and put one in the header and one in the footer. Can anyone help me with the vba code please?
  22. Replies
    31
    Views
    833

    Re: Measuring distances with vba

    I get a subscript out of range error with the following line highlighted

    iRow = Sheets("sheet1").HPageBreaks(1).Location.Row

    Even though you have told me what to do, I am not very good with the...
  23. Replies
    31
    Views
    833

    Re: Measuring distances with vba

    But how would I compare that to the image height to see if it fits?
  24. Replies
    31
    Views
    833

    Re: Measuring distances with vba

    I am going round and round in circles with my problem solving on this Mike. Could you help me please with the code for the custom image?

    I need to insert it below a textbox but if the image gets...
  25. Replies
    31
    Views
    833

    Re: Measuring distances with vba

    So this finds the top of the last row of the current page?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4