rangeactivecell

Hello, I have been having trouble with this code for more than a week, i have tried to find a solution but i could not 'THE BELOW IS MY DESIRED MAGIC LastRow = Range("A1").End(xlDown).Row Range("A1").Activate n = ActiveCell.EntireRow.Find("Requisition", LookAt:=xlWhole).Column Cells(1...

Hi, I'm lost on how to just simply copy a row from one sheet to another. I need it to copy to the other sheet that has an available empty row. Once that has been executed.. It will simply just delete the information on sheet1 after copying to sheet2. So far I have... Dim lastrow As Long...

I have the following code in VBA Sub Findfund() ActiveSheet.Range("a:a").Find("Investor").Select ActiveCell.Offset(1, 0).Select Range(ActiveCell, ActiveCell.End(xlDown)).Select End Sub However the Range(ActiveCell, ActiveCell.End(xlDown)).Select is giving me a...

my cell range is A2:C2. i need cell range A2:C2 use in blow code instead active cell how it is correct Cells(Rows.Count, 2).End(xlUp).End(xlToLeft).Offset(0, i - 1).Select Range(ActiveCell, ActiveCell.End(xlUp).Offset(1, 0)).Value = Controls("TextBox" & i).Text

I have the code below that i was hoping that there could be something modified so I could hit undo if the rows were not added at the correct place. Sub Insert4() Range(ActiveCell, ActiveCell.Offset(3, 14)).Select Selection.EntireRow.Insert For n = 7 To 10...

Can't understand why this doesn't work... Range(ActiveCell, ActiveCell.Offset.End(xlDown).Offset.End(xlToRight)).Select PartID = Range(ActiveCell, ActiveCell).Offset(0, -2).Value MsgBox (PartID) Selection.Name = PartID I selected a range of cells; set 'PartID' to pick up the value...

Hi guys, so im having an issue figuring out something. I'm trying to write a code which changes the color of a cell depending on if its greater than or less than a different cell. as a formula, i would have done $E2, however, when i put $E2 in vba, all the cells then reference only E2, i want it...