I am trying to select a column range by first finding which column has the title I require (in this case "UseThis")
Then I want to select the range from that address (f.address) and offset it by a number of rows (in this case I am using 100)
The code works and msgBox shows $H$1 as expected...
I'm struggling on figuring out why this is giving me an object required error.
Private Sub CommandButton2_Click()Dim ws As Worksheet
Dim wb As Workbook
Dim Answer As String
Dim MyNote As String
'Place your text here
MyNote = "Do any of your Providers have more than one specialty?"
The Script I use worked perfectly until now. The last time I ran it was last month "March 2018". The script itself is very simple.
I open an Excel Workbook ( only one), execute the script from SAP SCM.
The script reads one MARKET at a time and then runs trough a list of steps.
I am an excel beginner trying to make a UserForm for data entry. I made the UserForm and had it working, then accidentally saved the file as the wrong format and had to make a brand new one.
I was able to copy the code and add it into my new VBA with all the same box names, but now when...
I am getting ## Run-time error '424': Object required ## when executing the code below:
Private Sub CommandButton2_Click()
'Application.ScreenUpdating = False
Dim xlWB As Workbook
Dim xlWS As Worksheet
Set xlApp = New Excel.Application
pathfile = "Tracker.xlsx"
So I am trying to create a macro that reads the value in my Worksheets('Main Page").Range("B13") and then goes and searches through the rest of my sheets and will delete that entire row, in which the value is found. I am receiving an error that says "Object Required". Any help would be great...
This is the First Macro i've ever tried to create. There is two but they are both giving the same error. Any help is appreciated!!!
If L2LCheckBox.Value = True Then
'L2L True Macro
ActiveCell.FormulaR1C1 = "=RC-RC-R[-12]C[-3]"...
I'm quite new VBA coding, and particularly to coding for UserForms. I'm trying to make a UserForm tool to enter information into a database. I have created a number of UserForms which I want to link with buttons such as Next or OK. The .Show method works fine for most UserForms I have...
Windows 7 excel 2007
Im real new at VBA (but do know some PHP if that helps lol)
ANYWAY a website had a way to copy and past without using the clipboard link here: "Optimize Slow VBA Code. Speed Up Efficient VBA Code/Macros"
Im new to vba. Literally started learning the language 3 days ago. I have created a textbox within a userform so that my users can input a date. But i keep getting "object required." please help. here is my code.
Dim Final_Date_of_Service As Date
I have had a shot at some code that will check if a cell in the selected range has a formula and if so add this formula as a text string in the same cell's comments.
Public Sub CellFormulaToCellComment()
Dim CellInRange As Range
'Dim CellComment as String
For Each CellInRange...
I finally got my code to compile, but can't run it due to an 'Object Required' Error. Runtime 424 Error from the worksheet button.
I think it's because I need to us a SET statement when assigning a value to an object, but since I'm not using an array I'm not sure where it needs it! code below...
I'm eceiving an Invalid Qualifier Error for LastPartNo in Sub InputPart, even though I have clearly defined it as an Integer before I tried to use it.
I attempted dding a Temp Str type as a go between in case of a type mismatch. Still no luck. Ay help would be much apreciated! :)
I'm currently making an excel workbook where a user inputs a range of data which gets processed and reorganised into a table like the one below found in the "Intermediate" sheet in the workbook. There can be anything from 1 series to dozens, even hundreds.
I am having issues with this code calling the public function EditEntry on frmRunEntry
Private Sub CommandButton1_Click()
Dim Response As Long
Dim RowNum As Variant
'Get the record ID from the user
Response = InputBox("Please enter the ID number")
'Test the user input...
The code snippet below is the subject of my question.
If r = 7 Then
analyte = "Horizon Depth to Top"
If Cells(r, K) = 6 Then
Err = Err + 1
stream.WriteLine analyte & " is missing in cell " & KOL & r & ", please...
I'm having an issue with my InputBox command, I have underlined the part that's returning the error.
On Error Resume Next
'Need to let the user select the proper heading.
Dim rng As Range
Set rng = Nothing
Set rng =...
I am having trouble with the following code where I get a Compile Error: Object required error on the first set command. I'm obviously missing something right in front of me, but I can't spot it. Why doesn't it like hHeader?
Thanks for looking at this.
Dim sh As...
I have designed a button to run a macro which deletes old information when pressed. I wanted to have a vbYesNo MsgBox popup to ask the user if the are sure they wish to delete data. This macro seems to work fine and completes its task but once it is finished I am getting "Object...
I have 2 Activex ComboBoxes on a sheet and I am trying to populate the range in the 2nd combobox based on the value in the first combobox.
Here is my code. But whenever I run it, I get the following error:
"Runtime error 424, Object required" .. Please Help!