target.column

Hi, I'm using VBA as a drop down so that when I click on the selection it hides all columns except for the ones I need to see for that criteria. My problem is that once I have selected one of the options e.g Newcastle, to see the next option e.g. Carlisle, I have to go back to Select College...

Hey all, Very novice when it comes to VBA, but I'm pretty good at copy/paste and brute forcing until something works! I managed to come up with this code that allows multiple values to be selected from drop downs (target.column section) as well as copying and pasting a row from an "Open" tab to...

Hello All, I am trying to get two timestamps in one sheet. I have one range of cells (R6:AF6) and when someone types in any information in any of this range of cells I want a time stamp to show up in cell BH6. Now exactly the same I have this range of cells (AJ6:AX6) and when anyone types on...

Hi all, Please Help Me to Put this two Worksheet_Change To one Sheet: - First one: Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next If Not Intersect(Target, Range("R6:R1000000")) Is Nothing Then Hyperlinks.Add anchor:=Target, Address:=Target.Value...

Hello,</SPAN></SPAN> For now using 3 different worksheet functions to select entire C:H columns for 3 different targets cells "1st for L:V", "2nd for AB:AL" and "3rd for AO:AY"</SPAN></SPAN> Would it be possible use " Worksheet_BeforeDoubleClick" for all targets? </SPAN></SPAN> Data looks...

Hi There, Could someone take a look at my code and tell me how to fix it please? It's a simple code that was given to me by one of the forum members and after trying to implement it into my workbook I have come across an issue and have not been able to resolve it since. Basically I have an input...

Hi all, I have a problem and I cant get my head round how to fix it. Basically i have 2 columns with dates in, and i need the dates to be formatted correctly otherwise is messes up some of my formula's. So if the date contains "." or "-" i replace them with "/" If Target.Column = 1 Or...

Based on some earlier advice from Yongle, I've been using a worksheet to track progress on tasks, using the code below to record date, time and by who certain entries are made: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row = 1 Then Exit Sub 'ignore changes in header...

ok so I have this macro that works perfectly fine when I'm on this sheet. This is in a sheet that is called "RL". The issue I have is that the cells in the columns 12-19 on sheet "RL" are a result of a lookup from a pivot table. So they are formulas. So when the pivot table (which is a sheet...

A couple of years ago I constructed this code with the help of Mrexcel; Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim WasProtected As Boolean Dim response As VbMsgBoxResult Dim adjust As Integer On Error GoTo myhandler...

Hi guys , I am sure there is a better way of hiding columns than the code below that i am using. Basically I need to hide the columns based on the cell value of column and whatever row I am currently on and ignore the pervious cell value in column 20 value if that make sense. The spreadsheet...

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"...

Hi all, I have searched this forum for an answer but my understanding of VBA does not allow me to combine everything I have read. I have created a spreadsheet which has the dates for an entire year listed across row from E3 : BK3 Cell D1 is a drop down menu with Jan - Dec and "Annual" as...

I really need help. I need to put together a spreadsheet for my boss. I do not know VBA (at all - someone helped with the macro below) I have several issues. 1. Using the formula below in the Master sheet, I need to bold the name of the sites (Big Spring, Dubois, etc) when it returns a...

Hello, I have a macro that creates a timestamp when i change the value of a cell. Until recently it was working fine but now it's as if excel doesn't start the macro when I change the cell... any pointers? Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False...

Hi, I am very new to VBA and my piece-mailing some code I found through various forums, I was able to get my VBA Goal Seek to work. However, I have too many cells I want to goal seek. I've looked into how to try to sub routine my VBA but I'm completely lost. Any help is very appreciated...

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 :)...

I have a macro that runs based on a row and column range, for example the macro occurs if someone selects a cell in column 5-8 and row 3-48. However, these cells are in a table called "Tbl_Results" and as users may want to extend the number of rows in the table, so I would like this macro to...