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: 110,341 Posts: 607,307
110,341 607,307
Sub-Forums:
Excel VBA / Macros (5,672/28,259)
Excel Formulas (1,036/5,145)
Excel General (103,365/573,345)
Excel FAQ (165/175)
Code Review (26/139)
By using this HIRE HELP forum, you agree in full to the Terms & Conditions
Topics: 1,479 Posts: 16,854
1,479 16,854
Topics: 6,467 Posts: 28,494
6,467 28,494
Sub-Forums:
Excel and/or Word Help (1,262/5,235)
Excel and/or Access Help (2,607/11,480)
Excel and/or Email Help (1,271/5,469)
Excel and/or SQL Help (825/3,830)
No questions in this forum please.
Topics: 598 Posts: 2,432
Last Post: VBA Merge sort
598 2,432
trunten
VBA Merge sort
by trunten
Topics: 994 Posts: 6,585
994 6,585
Sub-Forums:
Newsletters (4/4)
Competitions (3/13)
HAV-A-CHAT (506/4,095)
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 1965 users online. 12 members and 1953 guests.

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

Free Excel\VBA Help Forum Statistics

Collapse

Topics: 124,601   Posts: 677,966   Members: 318,147   Active Members: 496
Welcome to our newest member, Sajoca.

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

  • Billyrj
    VBA strikethrough of cells
    by Billyrj
    I have been researching VBA to strike through text in cells when criteria is met.
    I was trying to use a ref cell that is a REF number and Strikethrough text in Cells 1-8 if the ref number is below the ref # and Greater than a specific date.

    The Ref # determines where you start and everything greater than DATE wise thats also provided on sheet1 My desire is to strikethrough text in cells A:M (1-13)
    I've researched and am unable to ID strike through....
    5 hours ago
  • Sajoca
    VBA to copy and paste
    by Sajoca
    Hi,
    I have a table as given in the sheet "06sheet".

    I have the code
    Code:
    Sub sixsheet()
    
    Dim rng, r  As Range
    Dim lastRow As Long
    
    With Worksheets("06sheet")
        Const n As Long = 5 ' Last number to be changed if nuber of top records to be changed
        Set r = .Cells.Find("*", .Cells(Rows.Count, Columns.Count))
        If r Is Nothing Then MsgBox "No data": Exit Sub
        Set rng = .Range(r, .Cells(Rows.Count, r.Column).End(xlUp))
        lastRow = rng.Cells(rng.Cells.Count).Row
        
        With rng.Resize(n + 1)
          'Union(.Columns(1), .Columns(3)).Copy r.End(xlToRight)(, 2)
        Union(.Columns(1), .Columns(3)).Copy r.End(xlToRight)(, 2)
        End With
    ...
    12 hours ago
  • coloroom
    UNABLE TO COPY "IF" STATEMENT RESULT CORRECTLY
    by coloroom
    The "IF" formula result reflect correctly on sheet called "Input", when use vba script to copy it to another, the value is different, need helppppp, thanks, i don't know to do programming, i copy the vba from internet and modify here and there..

    to simulate,
    if enter "1" on cell M6 and enter "1" on cell N10, then press CLICK button, the cell C4,D4,E4,F4,G4, H4 will not reflect the correct value on the SHEET "trasanction" row "U" till "Z", can some one help, thanks, i am newbie on excel formula...
    22 hours ago

Recent Blog Posts

Collapse

There are no results that meet this criteria.

Trending on OzGrid

Collapse

  • Desauv
    SUMPRODUCT Partial Match - #N/A
    by Desauv
    Hi All

    I have below formulas, and both return #N/A

    Formulas
    =SUMPRODUCT(ISNUMBER(SEARCH(RIGHT(B417;5);skema!$B$2:$B$4000;1))*skema!$T2:$T4000)


    =SUMPRODUCT(--(LEFT(skema!$B$2:$B$4000;5)=RIGHT($B417;5))*(skema!$U$2:$U$4000))

    Example of Data
    B417 = A68247

    e.g $B$2:$B$4000 = 68247-01

    e.g skema!$T2:$T4000 = $500,21


    Hope someone can help

    Regards
    Stefan...
    1 week ago
  • FrankM
    adding a second condition to conditional formatting, both have to be true.
    by FrankM
    This formula works =AND(NOT(ISBLANK($K4)), ISBLANK($L4)), but I am not able to figure out where to put <> "TBD". I want L4 to fill with color if K4 is NOT blank & the entry in K4 <> TBD. I have searched & found dates, times, < & >. but nothing like what I am trying to accomplish. Is it possible. Thanks in advance.
    4 days ago
  • timrfitz
    Determine if shared workbook is opened on my machine
    by timrfitz
    I receive an error when I use Workbooks.Open on a shared workbook that is already open on my machine. I've tried examples of code posted on this forum to determine if the file is already opened, including:

    Code:
      
     Function IsWorkbookOpen(stName As String) As Boolean       'Boolean Function assumed To be False unless Set To True            On Error Resume Next ' In Case it isn't Open     IsWorkbookOpen = Not (Workbooks(stName) Is Nothing)     On Error Goto 0 End Function 
    but it always returns False. I think it isn't working because the file is a shared workbook. I tried the Microsoft supplied macro:
    Code:
     Function IsFileOpen(ByVal filename As String) As Boolean      Dim filenum As Integer, errnum As Integer      On Error Resume Next     filenum = FreeFile()     Open filename For
    ...
    2 days ago
  • harky
    Moving Sent Items To Another ARCHIVE Sent Folder.
    by harky
    Base on current (below) code.
    Possible to add on more function?

    Possible to move send email to ARCHIVE Folder once email sent on outlook?

    From Inbox 'sent folder' to ARCHIVE

    PST Name: SENT_ARCHIVE
    Subfolder: SendFolder

    Or nt, is there a code where i can put in outlook




    Code:
    Sub SendEmail()
        Dim i As Integer, Mail_Object, Email_Subject, o As Variant, lr As Long, d As Long
        Dim wks As Worksheet, pf As String, wPath As String, wFile As Variant, wPattern As String
        Dim num_err As Variant, sErr As Boolean
    
    
        'START of confirmation message box'
        response = MsgBox("Start sending email?", vbYesNo)
        If response = vbNo Then
    ...
    2 days ago
  • desktopace
    Read only open
    by desktopace
    I would like to know if you can open an excel workbook in read only if the computer user and computer name doesn’t match existing criteria. Example: if the main person to open the wb is computer name is WS2019, and the logon name is wsmith, but the computer name opening the wb is RS2019 and the login name is rgraves, then I need the excel wb to open up in “read only” so the the excel wb cannot be saved and if changes need to be made, only wsmith can open it and make the changes. I have multi-users that use this excel workbook everyday and if changes need made, only I know how to make them. I am not always the first to open it up and so if changes needs made, I have to get everyone to close the wb so I can open it and make the changes. I also don’t want the possibility that the wb can be...
    5 days ago
Working...
X