target.row

I need a little guidance. I do not want to use Data Validation to restrict data entry in the cells as the warnings for accidentally typing will decrease productivity. I want the user to be able to select from the list in the Table column C and it lock the unnecessary cells so they can quickly...

Awhile back Val was kind enough to write the following code for me which has worked very well up till now. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 3 And Target.Row = Me.Cells.Find("*", searchorder:=xlByRows, searchdirection:=xlPrevious).Row - 2 And...

In A Double-Click Event Macro I'm Having Syntax issues in getting the 2nd code line to "take" Lr = Range("C" & Rows.Count).End(xlUp).Row If Not Intersect(Target, Range("N & Target.Row & ":P" & LR)) Is Nothing Then What's the proper syntax? TIA, Jim

Hi All, I am very stumped at the moment. I am using the below code to copy cells if the Sales person selects an option: Private Sub Worksheet_Change(ByVal Target As Range) Dim R As Range Dim s As String Dim Rng(1 To 8) Dim NV As String...

Afternoon, I currently using this code below so it runs when i open the worksheet. Private Sub Worksheet_Activate()Range("A4").Activate End Sub I am only interested in Column A The range is ALWAYS A4:A28 What i would like please "as opposed to going to A4" is that when i open the worksheet...

Afternoon. On my worksheet i type in values but when i type REFUND "only ever in a column C cell" the text is automatically turned red & also in the row in question at cell D i see in red £0.00 I then continue to enter the refund value in this cell so when i type £50.00 it then turns to -£50.00...

Morning all, Hope you had a good Christmas. Below is a current working code which not only does it high lite the row but also the active cell. I now have a sheet which i would like to use it on BUT i need to also high lite the column as well as the row / active cell. The columns in question...

Hi, I'm trying to track changes from the the sheet "Main" and document/track these changes back in sheet "Tracking". However when I make some changes in sheet main, nothing happens in the sheet tracking. Any idea why? The code I'm using is the following: Dim oldAddress As String Dim...

Hi, if someone could help, I'd greatly appreciate it. I've been working on this all week, and I can't find any solutions that fit my problem. I am using the following code and it works perfectly for Row 3 (first row of data entry). This sheet will go on forever as a living document so I need...

Hi Please could somebody help with an issue I am currently experiencing? I have the following code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim thisrow As Long If Target.Column = 3 Then thisrow = Target.Row Range("B" & thisrow) = Range("B" & thisrow)...

Hi all i need some help with a vba code.What i would like is a date stamp placed in a list in a worksheet in a shared workbook when each user updates their particular tab in the workbook.The date stamp need to include user name date and time in the following format username dd/mm/yy...

I'm a complete novice with VBA codes, I've added the below to hide columns based on a drop down menu but I also want to hide tabs based on the same drop down menu but have no idea how, any ideas? Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 And Target.Row = 3 And...

Hello all , I have a problem with a code. I want to hide a number of columns, according to a value of a cell. If value is ='1' unhide "E:K" and hide "E:K". If value is ='2' unhide "E:K" and hide "F:K" If value is ='3' unhide "E:K" and hide "G:K" . . If value is ='7' unhide "E:K" and hide "K"...

I'm coming to you to ask for some help with this code : Option Explicit Dim lgn& Dim plage1 As Range, plage2 As Range Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False lgn = Target.Row Set plage1 = Range("C" & lgn & ",E" & lgn & ",G" & lgn...

a = (Target.Row - 11) / 3 Mya i know what is it for?

Dear Excel-Masters, As a newbie to this Forum I have a request I have been working on some hours now :stickouttounge: I have been charged with building an Excel-based customer database. Therefore, I wanted to build an Advanced Filter in VBA to copy the data from the database to a new sheet :)...

Hi all, I have the following code that might be a bit rough, but runs. The purpose of this part of the macro is call a conditional formatting subroutine and to then find the difference in value between two dates. What I can't do is add 1 to the difference in the dates. The point of it all is...

Hi, I'm trying to determine if a cell in a range of cells is double clicked. The columns are B and C and the Rows are 3 to the Last Row. My code looks like this: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim LR As Long...