activerow

Hi I have some VBA to insert / update a column on the active row when changes are made within a range on the active row. The vba is working when I use cell references, however when I use table named ranges it errors. Private Sub Worksheet_Change(ByVal Target As Range) 'Update CRM date when...

Hello, Thank you in advance for any help you may provide. I have cobbled together a VBA code that seems to be working, I just cant get it to paste the copied data correctly. VBA uses a search box for a user to enter data, it searches Column M for a match and if found it copies a range of cells...

Hi All I am just having some trouble with a few lines in a macro i am trying to create. Currently i am in an active cell on one of my tabs which is a date. I would like to use this date to find a matching date in another sheet in the currently active row. For example if i am in row 43 on my...

I had an if condition written and it worked just fine, but I want to add to it a condition that will allow the code to stop a couple lines before the end of the code, but the else if won't work. I keep getting an error saying "Compile error: expected: Do or For or Sub or Function or Property"...

Hello you brilliant people of the internet! :) I have a smaller problem with getting vba to do what I want it to (big surprise there) So, my task is two part, but starts roughly like this; I have an "embedded if/and" that returns a value if two cells match. The value is from 1 to 10. Now I...

Working on PC using excel 2016. I have a userform macro that once filled out takes to user to the applicable worksheet and selects the applicable row. What I can't seem to get fixed is autoscrolling that work sheet to the active row. The active row location is always unknown (could be the...

Hello all, and thanks in advance I'm writing a small macro and am beating my head against the wall on a simple problem. (Excel 2016, PC, been 3 years since I've done any VBA). I have data from 2 cells (A1 and B1) that I have concatentated into cell A3. The string in A3 now matches the name of...

Morning guys, I have a spreadsheet whereby the user completes user forms which populate a log, this all works fine. the user selects the date on the userform from a date picker calendar, what I want to happen is, the date gets imported to next available row column c. id like active row column d...