application.statusbar

  1. I

    Access Statusbar in a specific workbook

    I often have several workbooks open. When I run one of my macros, I output to the Statusbar using Application.StatusBar but that output to the statusbar in all of my workbooks. Is there a way to specif which statusbar you want to output to?
  2. N

    Code works in immediate window, not from button click

    Hi all, I have a relative simple sub that I am running to change the name of a reference in a cell(we are replacing a worksheet, I'm looking for references to the old worksheet and replacing the name). It works perfectly when I run it from the immediate window, but if I call it from a button...
  3. J

    Run-time error trapping question

    Back again folks with another question that is plaguing me and I am hoping someone will rescue me once again. The site that I am trying to scrape from is https://www.poloniex.com/exchange#btc_dgb The code that I am using is the following: ' Dim IE As New InternetExplorer Dim...
  4. P

    Avoid Copy PasteValue statments

    Hi Is there a way tocapture the array in AA26:AH43 and then put the values abck to the sheet at theend of the sub I have a routinethat triggers a Stats App (BERT) by changing Go to 1 and then back to 0 I want to capturethe array within the trigger state But I want to avoidthe paste values...
  5. P

    Simpler loop

    Hi All and HNY2019 Is there simpler and cleaner way to code this to make the Status Bar appear to flash? Sub StatusFlash() Do Until c > 5 Application.StatusBar = "Setting up - " Application.Wait (Now + TimeValue("00:00:1")) Application.StatusBar = "Setting up -...
  6. D

    VBA causes excel to crash

    Hello! If anyone can help me out with suggestions, I would appreciate it. The coding I have below will run fine if I step through it, but if I run the macro it runs part way and crashes excel. It's been modified several times, but what I'm trying to do is copy specific excel tabs and save them...
  7. A

    TimeValue in Macro linked to cell in worksheet

    Hi I have the below progress bar which goes from 10% to 100% changing every 2 seconds and runs in the status bar. This works fine.. I run 12 main macros that need the progress bar to run and each macro will have a variable amount of records to process, and changes each time I use the...
  8. K

    VBA error 'Object required'

    The code below is returning error: Run-time error '424' Object required, marking line lr = wb_ReportFra.Sheets("g1").Range("A" & Rows.Count).End(xlUp).Row As far as I can understand I'm pointing out both wb and sh in this line, so what's the problem... :) Anyone that can spot what's wrong - and...
  9. N

    Slow loop processing

    I was asked to find and replace pound signs with a percentage sign in a particular workbook. Rather than doing find and replace all, I want to loop through all worksheets in VBA and see if the first character in each cell is a pound sign, remove that pound sign and replace it with a percentage...
  10. H

    Best way to find and delete rows !

    I have a sheet that contains at least 97000 rows. I'm testing a VBA code to find and delete rows that contain certain word. my problem is that this works fine with fewer number of rows but gets stuck with larger ones. here is my code: Application.ScreenUpdating = False...
  11. L

    Code to divide whole column by a number doesn't work

    Hi Experts - I have below code as part of the workbook i am creating.. everything is working fine, except that when i am trying to divide the column by 1000000, it always turn zero after the macro is finished running. But when i run the code line by line (pressing F8), it is working properly...
  12. B

    Application.StatusBar Cell Address

    I am looking if anyone knows of a LIVE function or sub that would give the Cell Address in the numeric format(I am not sure the technical name for it). But lets say I select A1 - in the status bar it would I would see "Cell(1,1)" I thought of it when I found something someone had wrote that...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top