bit

Found this example online: Sub StatusBar() 'Code to monitor in StatusBar For i = 1 To 10000 Worksheets("Ark1").Cells(i, 1).Value = i 'StatusBar Application.StatusBar = "Macro is running... Percentage complete is " & Round((i / 10000 * 100), 0) & "%" Next 'StatusBar End...

Hey everyone, I have been looking online for the location of the date picker but all I have seen is that with 2016 64 bit versions of excel its a no go. Is that still current or has it been added. I have seen some addins but it is for a shared worksheet and if possible i would like to find a...

For some reason, my sheet names are being auto-renamed with the file name. I've never seen anything like this happen before, and Google doesn't seem to offer any answers as to the cause. I do have a bit of VBA in my workbooks, but nothing is renaming worksheets. Here's an example: Visuals...

Hi I am trying to tell if there is a different sum amount from 2 different sheets Sheet2 and Sheet 1 I am trying to use a formula to match the ID numbers in sheet2 and Sheet1 in both column D and then look at columns (I) on sheet 2 and (Y) on sheet1 and return the difference if any or if the...

I am trying to sum the products of a cell in a few sheets, based on various arrays...needless to say, it wont work... this is what i've got...

I have a need to be able to discover if there is anything on the Office Clipboard. An item count would be perfect. I am using 64 bit - but can usually adapt 32 bit instructions. I am reluctant to try the alternative of using the system as this would raise a whole new range of questions - though...

Hello All, I have in the past found loads of help from other posts on this site, but I am a bit stumped now. I am trying to create a timesheet that can calculate a shift whether that be a day shift or a night shift that spans midnight. Giving the total hours (this is the easy bit for me)...

I couldn't get Morefunc to work in 32-bit Excel with 64 bit operating system. I thought installing 32-bit Excel would allow for 32 bit add-ins to work.

Hello, Im using below macro till kill all formula in my workbook. Sub KillFormula() Dim sh As Worksheet Application.Calculation = xlManual For Each sh In ActiveWorkbook.Worksheets With sh.Cells .Copy .PasteSpecial xlValues End With Next sh Application.Calculation = xlAutomatic End Sub...

Hello: I'd been using this addin called XlXtrFun for years. It is very useful mainly for interpolate (splines, etc..). Now the problem comes because I suspect this addin doesn't work for 64 bit Excel versions. When we are trying to load the addin it appears a message when Excel is opened: "The...

Good Day All the Code Below works with 32 Bit what code For Excel 64 Bit ? Private Declare Function mciExecute Lib "winmm.dll" (ByVal lpstrCommand As String) As Long thanks

Hello, I want to convert this: Excel 2016 (Windows) 32 bit NameDateHours Bob1/1/20174.5 Bob1/1/20173.5 Bob1/2/20174.5 Bob1/2/20175 Mary1/1/20173.5 Mary1/1/20173 Mary1/2/20176 Mary1/2/20172.5 Sheet: Sheet1 to this: Excel 2016 (Windows) 32 bit NameDateHours Bob1/1/20178...

Good Day All I need Macro to Play Sound File format m4a from Excel 64 Bit Thanks

Monday morning brain lock.. Im looking to show percentage growth my current formula used is: Find the percentage of change between two numbers A company sold $485,000 in 2011 and $598,634 in 2012. What’s the percent change between the two years? First, click in cell B3 to apply the...

Hi Everyone, I've encountered a bit of a problem and would love some help with some coding & VBA . I have a personal finance budget and I usually go through different months (cell F2 in overview sheet which I have since defined & named as "Period" ) to check things. This is a drop-down list...

HI We are using oracle database 11g. Widows 8.1 64 Bit OS MS office -2013 32 Bit. We want to connect to database and run a query. Can i save the DB connection password without user entering every time when refresh the data. Can you please provide the required steps to achieve this...