happening

Hi, macro is set up as below Sub Start Macro() application.screenupdating = false call macro2 application.screenupdating = true End Sub Now usually it works fine but the macro im working with does calculations on 30000 ish rows (takes around 90 seconds) and causes Excel to display "Not...

Hello, I've created a file which when re-opened seems to open twice and adds a "1" or "2" at the end of the file name. I have five data connections in my workbook, I did have hyperlinks but have since removed. Does anyone know why this is happening and why? I have researched online and some...

I have data in columns A - K to clean column A, I use: Columns("A:A").Select Selection.ClearContents this works fine, next step is to do something in column B, so I use Columns("B:B").Select ..... But now all columns with data are selected, not just column B...

Hello Everyone, It's seems so dumb to ask but I can't figure out why I am getting this error message: What I'm trying to do is open another workbook using the path that I provided. ERROR MESSAGE: Run-time error '13': Type mismatch Dim wsDatabase As Worksheet Dim path As String path =...

I'm trying to setup Conditional Formatting for a log to keep track of appointments/scheduling. Basically I would like any old (prior to today) highlighted in gray or grayed out, but when I set it up, it seems to only highlight the date and number/currency fields but not the text fields. What...

I am using a simple formula such as this: =COUNTA(Sheet1!D2:D20) The problem is that anytime a row is deleted from 1 to 20, the formula adjusts itself. How do I prevent this from happening? I have been tinkering with the INDIRECT function but have had no luck making it work. Thanks!

Here's how this has been going down in a lot of my workbooks: I hit "=" in a cell I want to create a link in I hit "Ctrl" + "Page Up" to get to the tab with the cell that I want to link to I hit the arrow keys to navigate to the cell that I want but there is no active cell box. The reference in...

Hi Guys I am getting this error when my workbook opens. This started happening when we upgraded our office to 2016 else without if and it brings me here If ActiveWorkbook.name = "Roof System.xlsm" Then Range("J1").Formula = "=today()" Else Exit Sub End If not sure why this is happening...

I have a document that I have quite a few Countifs formulas on multiple tabs and occasionally when I enter the formula and hit enter to complete the formula entry instead of returning the result it opens up a dialogue box as if I were going to open, save or link a file to the current file. I...

My problem is this: I have several data tables set up in my spreadsheet. For reasons I can not detect (it seems to be happening at random), individual rows within these tables are converting to fixed values. Obviously thereafter the tables do not work as intended. The 'surviving' cells in the...