-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
code edit
-
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...- splreece
- Thread
- Replies: 0
- Forum: Excel Questions
-
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
- Replies: 6
- Forum: Excel Questions
-
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...- nancylynn718
- Thread
- Replies: 4
- Forum: Excel Questions
-
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
- Replies: 5
- Forum: Excel Questions
-
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...- bamaisgreat
- Thread
- Replies: 1
- Forum: Excel Questions
-
Please check my code. Getting runtime error 9. Subcript out of range
sub try() Windows("trybook[2].xls1").Activate cells(1).select End Sub- pedie
- Thread
- Replies: 12
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
change colour of picture based on cell value
- Replies: 46
hello again guys I have found this video of Bills that explains how I could dynamically change the .width & .Height of a shape in excel, but I am... -
VBA - Combine Multiple workbooks into 1 worksheet
- Replies: 45
Hi, I am trying to write a VBA script which will combine multiple workbooks into 1 worksheet, copy and pasting all columns as values. Each sheet... -
Last Display on userform to a Listbox
- Replies: 35
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am... -
Vlookup and hlookup combination
- Replies: 28
Hello forum friends, I am using Excel 2016, XLOOKUP is not an option for me (I think). I have a worksheet that is linked to a website where the... -
Code giving run-time error when called, but not when placed on worksheet.
- Replies: 23
The code listed below runs on the worksheet, but gives a [B]Run-time error '424': Object required[/B] when called. I called the code, because when... -
Help with Current and highest streaks
- Replies: 23
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...