Announcement

Collapse
No announcement yet.

Forums

Collapse
  • Filter
  • Time
  • Show
  • New Topics
Clear All
new posts
No content found
Show More
  • Filter
  • Time
  • Show
  • New Topics
Clear All
new posts
Please log in to your account to view your subscribed posts.
Directory Topics Posts Last Post
Pick the APPROPRIATE category below to post your question and/or answer questions.
Topics: 109,810 Posts: 604,949
109,810 604,949
Sub-Forums:
Excel VBA / Macros (5,270/26,383)
Excel Formulas (963/4,904)
Excel General (103,325/573,178)
Excel FAQ (165/175)
Code Review (22/95)
By using this HIRE HELP forum, you agree in full to the Terms & Conditions
Topics: 1,461 Posts: 16,699
1,461 16,699
Topics: 6,459 Posts: 28,476
6,459 28,476
Sub-Forums:
Excel and/or Word Help (1,258/5,226)
Excel and/or Access Help (2,606/11,479)
Excel and/or Email Help (1,269/5,466)
Excel and/or SQL Help (824/3,825)
No questions in this forum please.
Topics: 596 Posts: 2,420
596 2,420
Topics: 992 Posts: 6,570
Last Post: Word Play
992 6,570
AlanSidman
Word Play
Sub-Forums:
Newsletters (4/4)
Competitions (3/13)
HAV-A-CHAT (504/4,080)
Test Area (459/2,379)
Links to Excel sites and Excel specific search engines powered by Google. Try it now!
Topics: 20 Posts: 22
20 22
abhi9139
VBA Replace text between brackets
Sub-Forums:
Newsletters (0/0)
Excel Blogs (1/1)
Charts (0/0)
Pivot Tables (0/0)
Solver (0/0)
Games (1/2)

What's Going On & Who's Online?

Collapse

There are currently 4551 users online. 10 members and 4541 guests.

Most users ever online was 13,741 at 02:14 on February 3rd, 2012.

Free Excel\VBA Help Forum Statistics

Collapse

Topics: 124,032   Posts: 675,331   Members: 317,136   Active Members: 562
Welcome to our newest member, Tsveti.

Welcome to OzGrid!

Collapse

Welcome to the community! Please take a moment to:

and if you have any questions - drop by in the HAV A CHAT forum!


Latest Topics

Collapse

  • Johnny912
    Multiple Linear Regressions with Identical Slopes
    Johnny912
    Is it possible to impose an identical slope during a multiple linear regression?

    See below I have 3 sets of data with a linear fit y=ax+b. I would like Excel to find the best a value that fits simultaneously the 3 set of data, and return the b values associated with that single a. Is it possible?

    Thank you very much for any pointers....
    4 hours ago
  • rholdren
    using offsets with a combobox1
    rholdren
    I have a piece of code that works well but I would like to take it to the next level. I have a series of vendors that are on a list and the code below works well. It searches the range locates the vendor code then the offsets copies the values onto another worksheet. what I would like to do is instead of having the same code repeated for each vendor I would like to use the list in combobox1 to select the vendor and have the offsets copy and paste the data into the other worksheet.

    Code:
    Sub AFCO_T()
    
    Dim Fnd As Range
    
    Sheets("2018Vendors").Select
    Range("A2.A400").Select
    Set Fnd = Columns(1).Find(What:="AFCO", After:=ActiveCell, LookIn:=xlFormulas, _
    LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext,
    ...
    10 hours ago
  • rholdren
    using offsets with a combobox1
    rholdren
    I have a piece of code that works well but I would like to take it to the next level. I have a series of vendors that are on a list and the code below works well. It searches the range locates the vendor code then the offsets copies the values onto another worksheet. what I would like to do is instead of having the same code repeated for each vendor I would like to use the list in combobox1 to select the vendor and have the offsets copy and paste the data into the other worksheet.

    Sub AFCO_T()

    Dim Fnd As Range

    Sheets("2018Vendors").Select
    Range("A2.A400").Select
    Set Fnd = Columns(1).Find(What:="AFCO", After:=ActiveCell, LookIn:=xlFormulas, _
    LookAt:=xlWhole, SearchOrder:=xlByRows,...
    10 hours ago

Recent Blog Posts

Collapse

There are no results that meet this criteria.

Trending on OzGrid

Collapse

  • mrhatter
    Best Method
    mrhatter
    Hi guys,

    I need some advise on the best way of compiling a little bit of software:-

    During the manufacture of one of our products we are required to record two numbers per unit, one bar-code that is scanned in and the other is a serial number that is typed in.

    I need to ensure that any new barcode/serial numbers entered are not or have not been duplicated - This in itself would be relatively straight forward but:-

    I will have four workstations running in parallel that will each have to record and check each entry in real-time.

    I'm stuck on the best method of doing this and even if Excel is the best medium to do so, would having a network sheet that the 4 workstations would write/read from work or would it get tied up?
    ...
    4 weeks ago
  • ganesh_6663
    Auto server site login macro giving error
    ganesh_6663
    Hi team,
    create one macro to auto login server site , first 2-3 login in different server are ok after that if i try to login same server which ready login using macro getting following error

    Run-time error "91"
    Object variable or with block variable not set



    Code:
    Sub SERVERGUI()
    
    Dim serverip As Variant
    Dim id As String
    
    serverip = UserForm1.servertext.Value
    id = UserForm1.TextBox4
    
        Set IE = CreateObject("InternetExplorer.Application")
        With IE
            .Visible = True
            .navigate "http://" & serverip & "/"
    
            Do Until .readyState = 4
                DoEvents
            Loop
    ...
    1 week ago
  • rholdren
    calling a DatePicker to change (reset itself) from a macro
    rholdren
    I would like to add a line to the sub below that changes the value of DatePicker1 back to 1/1/2019

    is there something I can add to this to make that happen?


    Code:
    Sub Field_Resets()
    
    ' Reset form values to staring points
    Range("B2").Value = ""
    Range("B8.B11").Value = ""
    Range("B14").Value = "Start Here - Use Dropdown to make selection"
    Range("B17").Value = "Start Here - Use Dropdown to make selection"
    Range("B23").Value = ""
    Range("B24").Value = "Start Here - Use Dropdown to make selection"
    Range("B26").Value = "Start Here - Use Dropdown to make selection"
    Range("B27.B28").Value
    ...
    1 week ago
  • phiyen8902
    The macro copy information from one chart into the summary chart
    phiyen8902
    The purpose of this macro is that coping informations from Discrepancy Report into Replacement chart. And I want to add more row Prepared by: Name into col W (issued by) of Replacement chart, but the code is not working. Pls run the macro and help me. Thanks in advance.
    Code:
    If Cells(DisReport_row, 1).Value = "Prepared By :" Then SumReport_col = Cells.Offset(DisReport_row, 2).Value
    ...
    2 days ago
  • Webbers
    VBA Macro - Highlight Row for Additions OR Cell for Changes
    Webbers
    Hello all!

    Okay, I have a template for another department I am developing. I need to add some conditional formatting via VBA. I managed to find a code on the forums and modified it. It meets one of my two requirements as is, but there is 1 change I would like (the range). I just either need a second code or modification to this code. I am still very new to Worksheet_Change coding. The code I found as works for "part 2 is below"

    Part 1 - Any NEW entry will require the entire row to be highlighted (I recommend in either orange or yellow... no preference).
    - The range of the data is columns A - DD
    - The number of rows will vary from week to week as this is a global workbook (so I would rather not be required to list a specific range)
    - The...
    2 weeks ago
Working...
X