Search:

Type: Posts; User: Gavin Harrison; Keyword(s):

Search: Search took 0.00 seconds.

  1. Filter over 3 Columns using 1 drop-down box

    Hi All.

    I've trying to code the following but not yet managed it!

    I'm looking to filter a data range let's say A5:C200. The criteria will be the value of a drop-down box in D1 selected by...
  2. Replies
    1
    Views
    191

    Loop not Looping!

    Hi All.

    Can anyone see anything obvious why the loop part of this code if not looping. Its doing everything it should except its just displaying 1 rather than 1 to 13 (TMs).

    Sub...
  3. Re: Auto add date in adjacent cell when data inputted

    Thanks footoo! worked a treat!
  4. Auto add date in adjacent cell when data inputted

    Hi All.

    I have the VBA code below whereby when data is entered into a cell in column C for example, the date that the info is entered is automatically entered into the cell in column B.

    I would...
  5. Re: Multiple occurance lookup and add the values

    Thank you, i knew i was making it more complicated than it needed to be!
  6. Multiple occurance lookup and add the values

    Hi.

    Ive tried a couple of formulas to do the below, but don't seem to be able to get one to work. Hoping somebody can help me.

    Essentially, I have a column with names (lets say column A) and in...
  7. Replies
    2
    Views
    477

    Re: VBA Code Translator

    Thank you very much for your reply.
  8. Replies
    2
    Views
    477

    VBA Code Translator

    Hi Guys.

    I only understand basic vba code and have taken over a project at work which involves what I think is quite advanced vba. I just wondered if a kind expert had 15 minutes to in some way...
  9. Replies
    4
    Views
    940

    Re: Save As VBA Code

    Thanks for the reply, I have just tried a different approach, which involves copying the sheets I wanted to save to a new workbook. The below code also allows the user to select the location of the...
  10. Replies
    4
    Views
    940

    Re: Save As VBA Code

    ok, so this is what I have so far, which completes the save as bit, but doesn't allow the user to select a location.

    Sub Export()
    ActiveWorkbook.SaveAs Filename:=Sheets("Great Rooms...
  11. Replies
    4
    Views
    940

    Save As VBA Code

    Hi.

    I have the below code that works fine to save my workbook as a PDF where the user specifies the location but the filename is specific. I now require if to still be an excel file.

    I would...
  12. Replies
    5
    Views
    166

    Re: Code error helppp!

    Hi Mark.

    it still errors at the paste line. I have got it to run the full sequence with this below code, but its not actually pasting the range?

    Thanks

    Sub Export()
    If MsgBox("Are you...
  13. Replies
    5
    Views
    166

    Re: Code error helppp!

    Hi.

    That code errors at the below section, do you think its beacuse if doesnt refer to it being a sheet that needs selecting defined by the contents of cell aa69?

    .Range("aa69").Value.Select
  14. Replies
    5
    Views
    166

    Code error helppp!

    Hi All.

    I have some code below, which always errors on the paste special line. If anyone can help i would appreciate it.

    It basically copys data from a hidden sheet and pastes the values into...
  15. Replies
    4
    Views
    176

    Re: Copying Formula Patterns

    Thanks Peter, that worked like a charm!!
  16. Replies
    4
    Views
    176

    Copying Formula Patterns

    Hi.

    I'm wanting to copy a formula down a column following a pattern, but obviously just by dragging the formula down the cells underneath doesn't work.

    Ive seen a few examples but I'm...
  17. Replies
    5
    Views
    566

    Re: Filepath in VBA

    I have updated my original code to:

    Sub Save_Excel_as_PDF()


    strfile = ThisWorkbook.Path & "" & strfile
    myfile = Application.GetSaveAsFilename _


    ActiveSheet.ExportAsFixedFormat _
  18. Replies
    5
    Views
    566

    Re: Filepath in VBA

    Hi Brian.

    Currently the file name is defaulted to the contents of cell AI3 which is essentially the week ending date, which is fine. But my original code 9/10 saves to the folder the file is...
  19. Replies
    5
    Views
    566

    Re: Filepath in VBA

    Hi Brian,

    Thanks for the reply.

    Is there anything I need to make specific as this is going straight to "could not create PDF file"

    Thanks again.
  20. Re: Recorded Macro to Paste Special Values not working

    Thank you!!
  21. Replies
    5
    Views
    566

    Filepath in VBA

    Hi all.

    I'm hoping you can help.

    I have a excel sheet, with a macro to export as a PDF. See below, But I would like to either set the destination folder or initiate the save as dialogue box so...
  22. Recorded Macro to Paste Special Values not working

    Hi.

    Im hoping somebody can help me, I've recorded a macro to copy a range of data and paste onto a separate tab, it involves unprotecting the workbook and unhiding the tab that the data is being...
Results 1 to 22 of 23