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: 106,471 Posts: 589,935
106,471 589,935
Excel VBA / Macros (2,791/15,257)
Excel Formulas (477/2,438)
Excel General (103,024/572,024)
Excel FAQ (165/175)
Code Review (8/41)
PLEASE PAY (via PayPal) 10% of your cost to [email protected] BEFORE you post. Then pay the remaining 90% to the person who completes the job on completion.
Topics: 1,372 Posts: 15,971
1,372 15,971
Topics: 6,408 Posts: 28,368
6,408 28,368
Excel and/or Word Help (1,245/5,197)
Excel and/or Access Help (2,598/11,463)
Excel and/or Email Help (1,261/5,453)
Excel and/or SQL Help (820/3,814)
No questions in this forum please.
Topics: 592 Posts: 2,384
592 2,384
Topics: 974 Posts: 6,368
Last Post: Word Play
974 6,368
Word Play
Newsletters (4/4)
Competitions (3/13)
HAV-A-CHAT (481/3,875)
Test Area (458/2,379)
Links to Excel sites and Excel specific search engines powered by Google. Try it now!
Topics: 18 Posts: 20
18 20
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 1280 users online. 8 members and 1272 guests.

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

Free Excel\VBA Help Forum Statistics


Topics: 120,481   Posts: 658,510   Members: 310,526   Active Members: 1,041
Welcome to our newest member, pjad57.

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


  • pjad57
    Macro to copy contents within active row

    I have a worksheet where I need to copy the contents from one cell to 6 different, contiguous cells in the same row. Example:

    Column C holds all the numbers needing to be copied.

    Cell C10 = 50000

    Needs to be copied to cells J10, k10, l10, m10, n10, o10.

    The macro needs to be repeatable throughout the worksheet from whatever row is the active row. Please help. Thank you.
    6 hours ago
  • neildeilyo
    Removing Rows - Code Too Slow
    I have the following which I am using to remove all rows of data where the name in column DX is not a specified name.
    The code will sort through all rows and delete each row that doesn't contain that specific name.
    The problem is, it is way too slow. Any thoughts?

    Sub DeleteNonName()
    Dim Firstrow As Long
    Dim Lastrow As Long
    Dim Lrow As Long
    Dim CalcMode As Long
    Dim ViewMode As Long
    With Application
    CalcMode = .Calculation
    .Calculation = xlCalculationManual
    .ScreenUpdating = False
    End With
    With ActiveSheet
    ViewMode = ActiveWindow.View
    ActiveWindow.View = xlNormalView
    .DisplayPageBreaks = False
    Firstrow = 2
    Lastrow = .Cells(.Rows.Count,
    10 hours ago
  • mamun.ges
    Excel VBA Match Columns and Paste from One Workbook to Another
    I have data set in a workbook Name "A" sheet 1 like follwing:
    SL Name Gender Age
    1 Asley Female 21
    2 Johan Male 32
    3 Jack Male 31
    4 Rubi Female 28

    I have another worksheet Name "B" and sheet Name "Male" where
    all the "Male" categories...
    10 hours ago

Recent Blog Posts


There are no results that meet this criteria.

Trending on OzGrid


  • Erik PLS
    Hide entire row based on value of one cell
    Erik PLS
    Hi, I am new to Ozgrid and registered because I have already found many helpfull forum threads here.
    Now I have a thing on my mind I can't seem to fix:

    I am not completely unknown to programming, but most is learned by trial and error, and a lot of internet searches.

    I have a semi dynamic orderform which is used for several departments in our company.

    With formulas in the excell form I give a preset value to each cell in column M; value will be V or D (Visa or Dölj/View or hiDe) I can change this to any other value of course.

    I want to hide every row of which cell in column M has value D, and view every row of which cell in column M has value V.
    After excesive searched over via Google I have found several simular problems, but...
    August 28th, 2017, 20:31
  • brajpalshishodi
    Run Time Error 1004 - Autofilter method of Range Class failed
    Hello Guys!

    I am facing an usual problem in the form of Run Time Error 1004: Autofilter method of Range Class failed. Below is my code and this error is occurring on Srng.AutoFilter Field:=2, Criteria1:="=*Express*", Operator:=xlAnd
    It was working fine as of now but when workbook open for the first time, it throws this error, so kindly look into it and let me know how can it be rectified.

    Sub Sort_With_Express()
    Dim wbNam As String, ws As Worksheet, lr As Long, Srng As Range, Frng As Range
    wbNam = ActiveWorkbook.Name
    Set ws = Workbooks(wbNam).Worksheets("7-Non US")
    lr = ws.Range("A" & Rows.Count).End(xlUp).Row
    Set Srng = ws.Range("A1:R"
    September 4th, 2017, 18:55
  • Pratibha
    Choose either number
    Is there any formula in excel where the function chooses or selects any of the three numbers 10 or 100 or 1000 randomly and not any other number.
    But only these three numbers should be chosen at random either 10 or 100 or 1000 and every time I reset the chosen number should change.
    For eg if one time it it chooses 10 next time it should be either 100 or 1000
    September 4th, 2017, 20:07
  • legin52
    Variable number of rows of data
    I am hoping somebody can help me as my knowledge and logic have been exhausted.

    I have a workbook with 2 sheets in it.
    ‘Printer Macro’ from here known as ‘1’
    ‘Printer Header Sheet’ from here known as ‘2’

    A set of data is imported to ‘1’. It occupies columns A to L
    However the number of rows occupied changes each time the project is run and it is this that is causing me problems.
    What I am trying to achieve is:
    Step1: Select A:L from row 1. Copy the data. Go to ‘2’ and paste (values and format) into cell A2 of this sheet. Then print sheet ‘2’.
    Step 2: Repeat Step 1 but with Row 2 (A:L from ‘1’). Then paste into the same cell as step 1 (i.e. A2 of sheet ‘2’). Then print sheet ‘2’
    This repeats for...
    4 weeks ago
  • dorian777
    Linking to externat data from Excel online
    I wonder if it is possible to connect to ANY data source from an EMBEDDED excel workbook (original is stored in one drive)?

    I tried setting up a WEB QUERY in desktop excel and then online excel says it does NOT SUPPORT WEB also say IT DOES NOT SUPPORT LINKS TO EXTERNAL WORKBOOKS....

    BUt it has the option to refresh connections....what are they??????

    Do you know?
    3 weeks ago