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,290 Posts: 602,518
109,290 602,518
Sub-Forums:
Excel VBA / Macros (4,880/24,578)
Excel Formulas (895/4,525)
Excel General (103,279/573,006)
Excel FAQ (165/175)
Code Review (20/81)
By using this HIRE HELP forum, you agree in full to the Terms & Conditions
Topics: 1,448 Posts: 16,568
1,448 16,568
Topics: 6,456 Posts: 28,471
6,456 28,471
Sub-Forums:
Excel and/or Word Help (1,257/5,225)
Excel and/or Access Help (2,604/11,478)
Excel and/or Email Help (1,269/5,466)
Excel and/or SQL Help (824/3,825)
No questions in this forum please.
Topics: 597 Posts: 2,417
597 2,417
Topics: 992 Posts: 6,565
Last Post: Chat Room
992 6,565
rakesh74
Chat Room
Sub-Forums:
Newsletters (4/4)
Competitions (3/13)
HAV-A-CHAT (504/4,077)
Test Area (459/2,379)
Links to Excel sites and Excel specific search engines powered by Google. Try it now!
Topics: 19 Posts: 21
19 21
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 6738 users online. 19 members and 6719 guests.

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

Free Excel\VBA Help Forum Statistics

Collapse

Topics: 123,492   Posts: 672,666   Members: 316,061   Active Members: 514
Welcome to our newest member, Ajaxriver.

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

  • naira
    Databar based on another cell value using VBA/ Macro
    naira
    Hi!

    As per Standard Excel the length of databar is equal to the value in the cell where the databar is displayed (subject to upper and lower limits specified in other cells).
    Following macro allows me to create a Databar using min. and max range between cells A3 to A4, and the databar is displayed in cells A2 to A4.
    Code:
    Sub databars() Dim rg As Range Dim db As Databar  Set rg = Range("A2", Range("A3").Range("A4")) Set db = rg.FormatConditions.AddDatabar  With db    .BarColor.Color = vbGreen    .BarFillType = xlDataBarFillGradient     End With  End Sub
    I was wondering whether it could be possible to modify the macro to display the databar in Cell A1, with the databar length corresponding to value in cell A2 and min/ max range being held...
    7 hours ago
  • naira
    Databar based on another cell value using VBA/ Macro
    naira
    Hi!

    As per Standard Excel the length of databar is equal to the value in the cell where the databar is displayed (subject to upper and lower limits specified in other cells).
    Following macro allows me to create a Databar using min. and max range between cells A3 to A4, and the databar is displayed in cells A2 to A4.
    Code:
    Sub databars() Dim rg As Range Dim db As Databar  Set rg = Range("A2", Range("A3").Range("A4")) Set db = rg.FormatConditions.AddDatabar  With db    .BarColor.Color = vbGreen    .BarFillType = xlDataBarFillGradient     End With  End Sub
    I was wondering whether it could be possible to modify the macro to display the databar in Cell A1, with the databar length corresponding to value in cell A2 and min/ max range being held...
    7 hours ago
  • hklein
    get users with access to a shared mailbox
    hklein
    Hi, does anybody any experience how to get users from AD that have access to a mailbox?
    I don't really know where to start with this.
    Thank you
    8 hours ago

Recent Blog Posts

Collapse

There are no results that meet this criteria.

Trending on OzGrid

Collapse

  • natrajc
    Automatically Extract URL from Browser
    natrajc
    Hello Experts!

    Was wondering if someone could help me with the following:

    I need the url of any website opened by an operator to be copied into an Excel file with a date and time stamp.

    The operator uses incognito mode , too, at times.

    The idea of this is to be able to backtrack and find a particular operator who did not update the url (s)he opened to an excel sheet, which is what is required of the operator.

    Thank you in advance.

    PS

    Went through a search and found five pages that pulled up for a search on "Extracting URL automatically", but was unable to make any headway.

    PPS

    As evidenced by my past efforts in excel/VBA, I'm not the sharpest tool in the box
    2 weeks ago
  • scottparker101
    New code to write cell location
    scottparker101
    Hi


    mlooking for help with writing a macro to find numbers 1 to 12 and write the cell location of the found numbers.


    The cell range is as follows: B5:B16, F5:F16, J5:J16. Search for numbers 1 to 12. A positive result only occurs when the 3 cells to the right of a found number also has numbers in it. This is only a sample Excel sheet and I will have to make cell location changes for everything so please do not hard code. Also, could the positive number cell location be written to the corresponding number in the following cells:


    Number 1 write to cell location B2

    Number 2 write to cell location C2

    Number 3 write to cell location D2

    Number 4 write to cell location E2

    Number 5 write...
    1 week ago
  • palchy
    VBA to Hide/Unhide Cells with Zero
    palchy
    Hi there,

    What I am attempting to do is create one VBA script attached to a button that will toggle to either hide or unhide cells based on it containing zero. I have created the simply script below that works but it takes to long to run as it goes line by line which you can see happening right before your eyes.

    Code:
    Sub ToggleHideRows()
        Dim c As Range
        For Each c In Range("P76:P500")
            If Not IsEmpty(c) And c.Value = 0 Then
                c.EntireRow.Hidden = Not c.EntireRow.Hidden
            End If
        Next
    End Sub

    To try and speed things up I pieced together the following script but I could only get it to hide ALL the zeros in column "P" instead of a selected portion such as P76:P500....
    4 days ago
  • sobi_256
    Loops and similar cell delete
    sobi_256
    Hello

    Please see the attched file
    I am facing a problem
    I am looping through rows by looking only at I column and J column contents. If there are more than 2 rows similar based on I and J value then i delete the rest of rows. ( 2consecutive values in I and J can be similar but not more than that)
    the problem i am facing That it doesnt take into account the name (column I) and just take into account the values in Column J. What I want is that if the current cell and the cells up and below are similar then delete the row.
    For trying i change in I column one of the names , even then it deletes the row because the values in J column are similar.

    for example in current sheet by code should delete contents in 3 and 4 ( from g3 to m4)
    and leave...
    4 days ago
  • GIRISHBISHT
    How to Merge Multiple xlsx and xls files in one workbook
    GIRISHBISHT
    I have many xlsx and xls files in a folder containing 2-3 worksheets in each file. I want to merge all these files into one workbook. I have a sample code but it is not merging xlsx file, it is picking only xls files of the selected folder. Sample code is mentioned below. Help me.
    4 days ago
Working...
X