relative cell

  1. F

    VBA Sum from a specific cell to a relative cell

    Hi All I am looking for a little bit of advice for a formula in VBA. I created a macro but while testing it i noticed that this line of code was not going to be correct for all situations. ActiveCell.FormulaR1C1 = "=SUM(RC[-10]:RC[-1])" I would like it to sum from B3 to RC[-1] but of course...
  2. G

    Paste Absolute value with VBA

    I am new to VBA, but I have been able to edit my recording enough to get what I want to this point. Here is what I have so far: ActiveCell.Offset(-12, 0).Select Range(ActiveCell, ActiveCell.Offset(0, 16)).Select Selection.Copy ActiveCell.Offset(12, 0).Select ActiveSheet.Paste...
  3. timstring

    select relative reference

    This is a really ignorant question, because I should know the simple answer. I need a command that causes a selection over a range of cells where the column varies from one sheet to another. Here's what I've tried: ActiveCell.Offset(0, 0).Range("R[1]C[1]:R[2]C[" & LastCol & "]").Select I...
  4. P

    conditional formatting 2007

    Hi, I have a problem in conditional formatting in excell 2007. I want to condition format an entire column based on another relative column data. For example I want to set background of each cell in column A to red according to relative values in column D. If $A1 > $D1 then RED $A2 > $D2 then...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top