general

Can someone tell me what the symbol ^-1 means as I am trying to work out a formula =IF(ISERROR((((B7*0.48888)^-1)-(371^-1))^-1),0,(((B7*0.48888)^-1)-(371^-1))^-1)

I have a workbook with a couple of tabs of data in it. I'm using another workbook to query that original workbook so I can treat the tabs as a relational database. The issue that I have is that some data types are not importing correctly. For example - I have a column "Sales" in the original...

Is there a way to do any macro calls from a General position instead of the Worksheet_Change Mode? For ex.: Private Sub Worksheet_Change(ByVal Target As Range) CheckArea = "A1:G19" 'The area to be monitored PUT YOUR VALUE If Application.Intersect(Target, Range(CheckArea)) Is Nothing...

I have a list of Clients with ID NO'S and Location. I need to segregate those in different worksheets under A, B, C according to the Location. The ID No and Name should appear in the respective worksheets. Whenver the master list is amended or added the change should effect in the respective...

I have made a check register with the fill colors alternating between yellow and white every other one. Then I locked the sheet with the "Select Locked Cells", "Select Unlocked Cells", "Sort", "Use Autofilter", and "Edit Objects" check boxes selected. Now my problem is when I sort the list by...

Quick question, I want to reference a workbook that i mentioned quite a bit in my macro code. However, I want to be able to change this workbook by just changing one line of code rather than having to go into my rather long code to change it every time. Here's what I have so far: Dim...