code edit

  1. S

    simple report by date (last 7 days) - structure has changed.

    Morning all, I've been using a great piece of code given generously on this forum, however the structure of the file has now changed and Ive altered the code but the script keeps giving runtime errors. The file has the following user input cells: F1 = Date from H1 = Date to (so the user can...
  2. S

    Superb Excellent Macro needs minor tweaking: HELP PLEASE!

    Hi everyone, Good day to you all. A couple days ago, a kind sir by the name Mike Rickson gave me a macro to extrapolate a set of random numbers from a given range of numbers from column A:1 all the way to A:49 sitting on 49 rows. At the moment i am concerned for his wellbeing because he...
    • shuga
    • Thread
    • code & formula code edit macro - search vba -help
    • Replies: 6
    • Forum: Excel Questions
  3. N

    Enter current date by double click in one column; enter current time by double click in two other columns

    Hello,I am very new to VBA and I have basic knowledge of Excel. I have been doing some research and reading up on how to use codes in the VBA but I've run into some issues. I would like to enter the current date by double clicking cells within column A (A3:A1000). I would then like to enter the...
  4. E

    mass email i keep getting errors can some1 HELP ?? ? ? CLICK HERE !!

    i keep getting an error can some1 look at this and help me fix this code? or help me with the notes in this code Sub sendemail(what_address As String, subject_line As String, mail_body As String) Dim olapp As Outlook.Application Set olapp = CreateObject("outlook.application")...
    • eric86vabeach
    • Thread
    • code check code edit email addresses help me please sending vba e-mail
    • Replies: 5
    • Forum: Excel Questions
  5. B

    Need help merging some code

    Below I have 2 parts of code I need added to the large module below. I have tried this several times an cannot seem to get it correct. I no this is a little lengthy task but any help would be great Sub save_file() Dim wb As Workbook Application.ScreenUpdating = False Application.DisplayAlerts...
  6. pedie

    Please check my code. Getting runtime error 9. Subcript out of range

    sub try() Windows("trybook[2].xls1").Activate cells(1).select End Sub

This Week's Hot Topics

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
Top