grass

  1. I

    Merged code gives a Run Time Error

    Hi, I have two buttons on my worksheet but would rather have only the one. Thus meaning i need to merge the two codes together. The two codes are shown below. Once i run the code the first code runs & does whats its supposed to do but when doing the second part of the code i ger a run time...
  2. I

    Excel to save as pdf did not save

    Hi, Code supplied below but when i run it to save as a pdf file the line shown below in in yellow. .ExportAsFixedFormat Type:=xlTypePDF, Filename:=strFileName, Quality:=xlQualityStandard, IncludeDocProperties:=True Private Sub GrassSummarySheet_Click() Dim strFileName As String...
  3. I

    Could you check my code please

    Evening, I am using the code supplied below. I press the command button & the pdf is saved then the cells cleared so far all ok. If i press the command button again im expecting the message box to be shown to advise me that the already exists. This doesnt happen & the save continues once again...
  4. I

    Expenses code saves Income sheet ??

    Hi, I have an Income sheet which prints fine on a button & the code shown below. Private Sub GrassSummaryIncomeSheet_Click() Dim strFileName As String strFileName = "C:\Users\Ian\Desktop\GRASS CUTTING\CURRENT GRASS SHEETS\INCOME 2019-2020\" & Range("A3") & " " & Range("D3") & ".pdf"...
  5. I

    Save files in accordance of month etc

    Evening. I have supplied the code below that is in use & works as it should. Private Sub GrassSummarySheet_Click() Dim strFileName As String strFileName = "C:\Users\Ian\Desktop\GRASS CUTTING\CURRENT GRASS SHEETS\" & Range("A3") & " " & Range("D3") & ".pdf" If Dir(strFileName)...
  6. I

    Sort names in tables A-Z

    Hi, I have made some tables but having an issue trying to sort them. Some info for you. Worksheet is called INFO Tables have headers in row 1 GRASS NAME CV2:CV16 GRASS ADDRESS CX2:CX16 GRASS PAID CZ2:CZ16 GRASS MILEAGE DB2:DB16 What im looking to do is place a macro on a button which will sort...
  7. I

    Edit to working userform info

    The code supplied below is for 7 Textboxes. I have removed 2 of the Texboxes & replaced them with ComboBox1 & ComboBox2 When i now try to transfer data from userform to worksheet i see a msg telling me basicslly that i did not enter anything in the first ComboBox. How cam i add an edit to also...
  8. C

    Find the oldest date in one cell based on a search for a keyword in other column

    Hi all, I have a spreadsheet with around 20,000 rows with two relevant columns, date, another cell with "ingredients", the ingredients column can have anywhere from 1 to like 10 items in it, the date cell is in a few formats (sometimes with month/day/year sometimes just year, and in one case a...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top