activecell.row

Hi All Michael M (thank you) wrote the original code for me and I'm trying to make a change I want to replace a deleted formula in column C when I double click in a cell. (See formula below) If Not Intersect(Target, Range("c:c")) Is Nothing Then Target.Formula = "=IF(BS$2=""Fixture...

<!--StartFragment-->I have the following line in a VBA macro which is to written into a cell in the workbook as a formulae: ActiveCell.Offset(0, 1).Formula = "=LEFT((INDIRECT(""B""& ActiveCell.Row +1)),FIND("" "",(INDIRECT(""B""& ActiveCell.Row +1))&"" "")-1)" How do I turn the ActiveCell.Row...

Hello all, I am trying to create VBA code that will take the code below were column C is the e-mail and other data is taken from the work book but I want to change the file name (column F) to now include all files from one folder instead of one specific file. I can specify the folder in column...

Hi All I am using the code below to paste the formula in a cell. I am so very close. I can't get ="" to paste. The pasted formula that I'm trying to achieve: =IF(C4="",F3+CK3,IF(C3="",F3,IFERROR(INDEX(Instruments!Z$3:Z$68,MATCH(CI4,Instruments!AA$3:AA$68,0))+F3,""))) I need C4="" and C3=""...

Hi all I am using the code below to replace the formula in a cell with a BeforeDoubleClick event but I am getting a syntax error. (Ex: If a cell is missing the formula, I just double click it to replace the formula) This is the formula that I am trying to paste...

What would be the equivalent of Range("C" & ActiveCell.Row) for columns? Thanks Tom

I'm trying to look at data and each time it finds the word "TYPE" in column G, it does some formatting and copy/paste stuff, then moves on to the next instance. I figured a DO LOOP would work best, and it works for what I need until it reaches the last "TYPE", then crashes. I'm not very...

Hi, All... Thought this would be easy: mark startRow$ and endRow$, select those rows and delete. But NOOO of course it couldn't be THAT easy... This is what I tried: Range("A100000").Select Selection.End(xlUp).Select ActiveCell.Offset(-4, 0).Select endRow$ = ActiveCell.Row...

I have a workbook with data in columns A through Y. I want to filter by the word "UNKNOWN" in column X and highlight those rows yellow. I thought I could filter by that phrase and then find the top of the range by using startRow$, then find the bottom of the range by using endRow$ then...

On my Excel spreadsheet: web address is in B, username in C, password in D, UN ID in E, PW ID in F, Button ID in G, land page (to go to after logged in) in H. Right click triggers below macro for that particular row. Succeeds in opening address in B, however not seeing log in credentials being...

Hi all, I have this which works when "X" is found in one column: If Cells(ActiveCell.Row, "L").Value = "X" Then But what about when X can be found in one of three columns? If Range("R" & ActiveCell.Row & ":T" & ActiveCell.Row).Value = "X" Then That returns an error. Any ideas? I'd prefer...

I have a spreadsheet that is used to track whether expenses can be billed back to our clients. When I enter "Billable" in column T, I would like the same of four cells in the same row (G, I, L, O) to be placed in a column named "Billable" in the same row; if I enter "Non-billable", I would like...

II s there a better way to clean up the code below? When command button 1 is clicked, commandbutton 2-4 and togglebutton 1 should be turned off (false). Private Sub CommandButton1_Click() With ToggleButton1 If .Enabled = True Then .Enabled = False Else .Enabled = True End With...

Hi All I need to return to my current worksheet, Say 'Sheet1' , the value in a matrix on a different worksheet, Say 'Sheet 10' by using, I assume, Index, Match,Match lookup formula. This is complicated by the fact that the values to use for reference for the Index are on 'Sheet1' - Column= 'G'...

I wrote a function that works when I enter it one row at a time because it uses the ActiveCell.row function. But when I copy that function down all of the results are looking at the ActiveCell's row and not the row the function is on. Here is the command, how do I change it? CurRow =...

I'm trying to select cells B*:D* and H*:APP*. where *= active.cell.row. I do not want to select E*:G*. Can't seem to get this to work & would appreciate a little help please. When I try this code it selects everything including E*:G* Sub Macro1() Dim Ro As Integer Ro = ActiveCell.Row...