No announcement yet.


  • 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: 108,232 Posts: 597,005
108,232 597,005
Excel VBA / Macros (4,092/20,469)
Excel Formulas (752/3,720)
Excel General (103,168/572,482)
Excel FAQ (165/175)
Code Review (15/58)
By using this HIRE HELP forum, you agree in full to the Terms & Conditions
Topics: 1,423 Posts: 16,346
1,423 16,346
Topics: 6,446 Posts: 28,453
6,446 28,453
Excel and/or Word Help (1,253/5,218)
Excel and/or Access Help (2,603/11,474)
Excel and/or Email Help (1,266/5,462)
Excel and/or SQL Help (823/3,823)
No questions in this forum please.
Topics: 596 Posts: 2,410
Last Post: Locked File error
596 2,410
Topics: 985 Posts: 6,529
Last Post: Cross posting
985 6,529
Cross posting
by Shezmo1
Newsletters (4/4)
Competitions (3/13)
HAV-A-CHAT (495/4,039)
Test Area (460/2,381)
Links to Excel sites and Excel specific search engines powered by Google. Try it now!
Topics: 16 Posts: 16
16 16
Dave Hawley
$139.00 of FREE Software
Newsletters (0/0)
Excel Blogs (0/0)
Charts (0/0)
Pivot Tables (0/0)
Solver (0/0)
Games (0/0)

What's Going On & Who's Online?


There are currently 2070 users online. 19 members and 2051 guests.

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

Free Excel\VBA Help Forum Statistics


Topics: 122,377   Posts: 666,761   Members: 313,986   Active Members: 660
Welcome to our newest member, rcdenman.

Welcome to OzGrid!


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


  • rcdenman
    Userform Code for Search Function Not Working
    I found a website that shows how to create a userform to search, edit, delete or add new info to your spreadsheet. Everything worked great when i used their template and followed the instructions to add the code. I have added this code to my worksheet and the add part works but the search function (and possibly the delete and edit function since I can't get past the search part) will not work. I have combed the code at least 4 times, even going so far as pulling the original code and my modified code into a spreadsheet side by side but I cannot find a problem. It just acts like there is nothing to find. I have attached the workbook. If anyone could show me where the problem is I would be very grateful!...
    14 minutes ago
  • PieterGrove
    Refering to multiple sheets
    I have the following code as listed below, no issues.

    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim sh2 As Worksheet, a As Long, lr2 As Long
    Set sh2 = Sheets("Sheet 5")
    lr2 = sh2.Cells(Rows.Count, 1).End(xlUp).Row
    If WorksheetFunction.CountIf(sh2.Range("A1:A" & lr2), Cells(Target.Row, Target.Column).Value) <> 0 Then
    Select Case Target.Column
    Case 1, 2, 3, 4, 5, 6, 7
    a = sh2.Columns(1).Find(Target.Value, , , 1).Row
    With Cells(Target.Row, Target.Column)
    If Not .Comment Is Nothing Then .Comment.Delete
    .Comment.Text Text:=sh2.Cells(a, 2).Value & vbLf & _
    41 minutes ago
  • wakandoo
    consolidate date from different excel files with same headers
    Hello all,

    Can you guys help me with a macro that can consolidate data from differrent excel files with similar headers?

    My headers start from A3-K3

    Column A and B will always be filled but the rest may or may not be filled up completely.

    the excel files will all be saved in the same folder.

    the excel files in question may or may not have other sheets in their workbook

    the sheet that I need for the excel will be similarly named and it is " Tracker".

    I hope you can help me with this since I have searched for days for something similar that I need but I can't find any that works for me
    4 hours ago

Recent Blog Posts


There are no results that meet this criteria.

Trending on OzGrid


  • adygelber
    Insert string into Explorer address bar or solve ShellSearch issue
    Hello friends,

    Is there any possibility to insert a string into the Windows Explorer's address bar?

    To be more clear I want to search a folder, using Windows Find built-in function, by a keyword. To do this, I want to insert the following string into Explorer address bar:

    search-ms:displayname=My%20Search&crumb=Anyintegernumber%3A%3D" & "my string" & "%20OR%20System.Generic.String%3A" & "my string" & "&crumb=location:C%3A%5CTemp

    This will search c:\Temp for "my string" but unfortunatelly I don't know how to insert this into the address bar.

    Maybe you will ask why I don't use ShellSearch...I tried this but due to an unsolved issue it searches the same directory...
    September 3rd, 2015, 00:07
  • aton
    VBA to open Network drive without mappping the drive

    I am using the below 2 lines to open a mapped network drive:

    ChDrive ("V:")
    ChDir "V:\Folder1\folder2\folder3"

    My problem is that every user have a different letter on their machine as it's a mapped network drive. I have tried changing code to Can ChDrive ("\\") , ChDir "\\Folder1\folder2\folder3" but unfortunately it didn't work.

    Can anyone please advise on a code that map/search for network drive based on a drive name instead of letter?

    Thank you in advanced.

    January 7th, 2016, 05:41
  • AndrewAfresh2
    Playing a sound file in windows 7 using VBA
    Does the method to play a sound in VBA described here: work in windows 7? It uses winmm.dll which doesn't come up when I search my pc. Windows explorer IS showing hidden files and protected operating system files. Thank you
    January 15th, 2018, 05:50
  • eae
    Error 438 when opening a workbook
    I am still learning VBA, but I know this is most likely a simple mistake. The variable "isum" that I created to replace a workbook that daily changes its name is getting an error 438. I cannot open it using 'filepath & wb' because of the '&' so I made a variable for them both. I am trying to copy a section on a sheet from one workbook, pasting to another sheet area on a different workbook. Here is my code:

    Sub Summary()
    Application.ScreenUpdating = False
    'create variables
    Dim wb As String
    Dim filepath As String
    Dim isum As Workbook
    Dim CBD As Workbook
    'variables for file with changing date in name title
    filepath = "\\main\stuff\Summary"
    wb = "Today Summary " & Format(Date,
    3 weeks ago
  • Magdoulin
    Word Formatting by Excel VBA
    Hi guys,
    How is everything?
    I hope youíll be able to assist me with the following
    Iím trying to write a code which will open for me an existing word file, create for me a new one, and make the background colour of this newly created file as black and its font colour as automatic.
    So far Iíve accomplished the first and the second step with the following code;
    Sub TrialHere()
    Dim wkb As Workbook
    Dim WordApp As Object
    Dim WordDoc As Object
    Dim objWord
    Dim objDoc
    Set WordApp = CreateObject("word.Application")
    Set WordDoc = WordApp.Documents.Open(Filename:="File Path", ReadOnly:=False)
    Set objWord = CreateObject("Word.Application")
    Set objDoc = objWord.Documents.Add
    4 days ago