variables in formula

I found a function on this site that will strip the characters from a string and just leave the numbers. I would like to use variables as the object of the function. My current macro is finding different areas of my spreadsheet that I need to strip off unwanted characters. What I would like...

Hi, I need urgent help to develop a formula for the following: I have an extremely large data set, approximately 600,000 rows. There are a number of variables that need to be considered but basically I need to delete positive and negative numbers (hours paid) per employee (employee id), per...

Hi Guys, I’m looking for a starting point to tackle a problem Iunderstand, but not in enough detail to be really specific… Basically, I need to simply retrieve or apply calculationsto customer agreement numbers, some of which will have 1 single line of data,simple as I can then just take the...

Hi all :) I'm having a problem getting this macro going ... I have a file with 2 sheets, 1 named "DagelijkseKassa" which contains dates next to other info, the other is named "Fiscale attesten" which contains cells with the same dates, but on different locations. Row 8 of Fiscale attesten...

Greetings, I can't figure out how to properly use my stored variable to filter a table. Here is what I have so far: Sub Macro1 () ' Macro1 Macro ' Declare Variables to be used Dim ActSheet As Worksheet Dim SelRange As Range Dim FTE As String ' Set the Variables...

Hi Experts, Sorry this one has me stumped and I’m sure it’s simple, I would like to sum a column which has been created via VBA selecting different sections so the column “letter” it’s in and the length or number of rows will vary. Due to this I’m using the variables from the VBA code within...

Have several regions on a sheet- trying to sum up cells in each region. Can determine the row numbers for the first and last rows of each region but am looking for a way to use that in a sum formula. Here is where I'm at: in the selected cell, I would like to put a formula that will add all...

Hi all, I am trying to insert this indirect formula and have it copied over multiple rows but obviously I can't drag it down or each cell references the exact same cell as opposed to the one underneath it. The problem appears to be that I don't know how to properly insert the rnum variable into...

Hey guys can someone give me an extensive lesson on how to reference Just Rows, Just Columns or Cell objects in a FormulaR1C1 Formula. I Really need help with it, and I hope to display it in traditional "A1" format Here is an example 'Type Ref in C8 of a blank work book 'and type random...