I wrote a macro AutoPing() that allows to loop itself every 5 minutes. It works between before 23:50. But it gets error when it passes to next day (00:00).
Please help me solve this error. Thank you.
Hello, I am in the process of transferring a lot of the sheet calculations and conditional formatting into vba for efficiency and in the process I am receiving an error that I cannot seem to figure out, "run-time error 1004; method range of object worksheet failed". I have attached all the...
Hi ya'll, first time poster here! I've been struggling for a few days on making this work.
Context: I have a sheet called 'Imported Data' that contains thousands of rows of data & 15 columns. It will always contain the same 15 columns - the data comes from a | delimited text file. Through other...
I have been running this code successfully, for a while now. For some reason it just started throwing this error code:
Run-time error '1004':
Method 'Range' of object'_Global' failed
Sub New_Associate()
Dim NextRow As Range
Set NextRow = Range("A1" & Sheets("Helper").UsedRange.Rows.Count...
Is there something wrong with my code? Please help!
"Sheets("Web Query").Columns(10).Copy Destination:=Sheets("Tracker").Range("A1")" - This is a working code but I want the copied data start at Range("A5") or Columns.(1, 5)
"Sheets("Web Query").Columns(10).Copy...
Dear all,
I would like to solve a set of linear equations with VBA. I need to do this with VBA, because the number of equations is dynamic.
While executing I get the error as metioned in the title and the last line is highlighted. I read a lot about the error, but I couldn't find my mistake...
I created a Macros for a spreasheet that works wonderfully up until it saves. It works just fine on my PC but when someone trys to run it on another Networked PC it bug's out at the place in red below:
Dim dtDate As Date
dtDate = Date
Dim strFile As String
strFile...
I want to save an excel file.
-The file’s name and folders’s names will change each time a file is saved.
-I recorded a macro to save the current file, then added variables defined by InputBoxes so a user could name and save each file to the correct folder.</SPAN>
I get the error message...
Hello,
I am using below code to export Salary Payslip as PDF but i am getting below error while exporting.
after export few Page, i am getting "Run-Time error 1004" (Document not Saved. The Document may be open, or error may have been encountered when saving).
Code is below
Option Explicit...
Hi all. I cannot understand what is wrong here.
Dim Counter As Long
Dim Counter2 As Long
Dim AssociateList As Range
'Check Number of Lines with Reports Filled
Counter = 1
Do Until ThisWorkbook.Sheets("Tracker").Cells(Counter, 2).Value = ""
Counter = Counter + 1
Loop
'Check Number of...
I've been using the following Mac Excel Office 2008 macro SUCCESSFULLY (for years):
Sub Auto_Open()
With ActiveWorkbook
.SaveCopyAs .FullName & ".Backup:" & Format(Now, "YYYY_MM_DD_HH_MM_SS")
End With
End Sub
to save a backup copy in the files' parent directory in a filename.backup...
Howdy folks,
I've been working on this problem for quite a while, and I can't get it to work properly. I am creating a macro for someone where data is consolidated from multiple worksheets into two summary sheets. From there, based on options selected on a "setup" worksheet, multiple...
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.