activecell.offset

Please Help, I have been searching the internet for an answer but cannot get what I am looking for. Here is what I need to know how to do: ActiveCell.Offset (0, E40).Select ActiveCell.Offset (0, "The value of cell E40").select It seems so simple but I have not figured out a solution. TIA.

So I have the following script in my macros: activecell.Formula = "= IF(LEFT($I6,2)=""17"",""CTRL+G"","""") Instead of $I6, I need to use Offset so I can call the cell needed (and use the formula in mulitple macros). I thought I should edit swap out $I6 with ActiveCell.Offset(1,-12).Value but...

In general, is ActiveCell.Offset(row,col) or Cells(row,col) more efficient in referencing another cell?

Hello all, Long story short, I have a piece of code here that is supposed to compare two experts in a head to head style on who has more clients. Whoever has the higher number, the code should highlight the cell with the higher total. If they are tied, it then compares a second category, pace...

Hi All Can anyone help me please, as I have been trying to sort this out for ages, with no success. strName = ActiveCell.Value  strName = Left(strName, 10) ActiveCell.Offset(, -5).Formula = _ "=IFERROR(INDEX('[TEMP.xlsb]MASTER'!$A:$A,MATCH(TRIM(""*...

Hi I want to populate a userform combo/listbox - RowSource from a dynamic range that I created in a Sub according to which cell is clicked on (using activecell.offset). What do I specify for RowSource? Do I need to register the range name - how? Thanks for any help David

Hi, I am working on a macro wherein the condition is If the values on the cells on column L is equal to the next business day(ie 02/11/2017) then Activecell.offset (0,5)value= "TO PREMATCH" Can you tell me the code for the next business day?

Hi, I am trying to create a macro that will select a cell using the find feature and then using that cell as the first cell for a range. I can use the find feature to select a cell and use that cell to either select the last cell in that column or the last cell in that row but not both. I need...

I cannot figure out where i am going wrong with my code here, any help would be appreciated. I originally wrote this code to put the info into 1 of 3 ranges depending on which option button is checked. Now i need to also have it put the data into a separate worksheet in the first blank row. This...

All, I need help using the loop function to move to the next row while always following the Column order of "I, A, B, D, C, E, F, G, H" Currently, I have alot of identical code, only difference is the row number is increasing. There must be a way to utilize 1 section of code and have it run...

Hi I'm running Excel 2010 and would appreciate help on a #Name error when trying to enter a formula using active cell.offset via VBA ActiveCell.Offset(0, 4).Formula = "=If(ActiveCell.Offset(0, 1)>0,ActiveCell.Offset(0, 17) / ActiveCell.Offset(0, 1),0)" The above 'works' in that a 'formula' is...

Hi There, I need to calculate the difference between two dates (in days) using VBA. I want the date to be put into the active cell and the start date and end date are referenced from that active cell. I think that my variables are not declared correctly or I need to convert the...

2 parts to this question: 2 Workbooks Copies Data from wb1 to wb2 make changes in wb2 and override this information in wb1 -- (This part I got) This part seems confusioning and i thought a loop would be way to go, but not sure how to begin. Data which is copied back is as follows in...

Hi guys, I'm doing a spreadsheet for different countries with numerous Reports. Whenever I insert a report for an individual country, a row will be inserted below. ActiveCell.Offset(1).EntireRow.Insert However when I enter the value for report #1 for Bangladesh in the other columns (...

Hello: I am attempting to separate the contents of a column of cells using the "left" function. Specifically, I have a column of data such as "2Q 2010" that I need to split into a column for the quarter and a column for the year. I have constructed a Do...While loop to perform this function as...

I'm am very new to using vba in excel and i'm trying to write a code that splits the names from one cell into 2 cells and leaves out the "," between the names and the middle initial this is what i have so far but whenever i try to compile it highlight the first number Row = 2 and says "Compile...