application.statusbar

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?

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...

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...

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...

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 -...

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...

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...

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...

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...

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...

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...

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...