activate cell

Hello, I am trying to have an active cell within a range of cells populate into an empty cell at the top of the column range. I'd like to do this at the top of multiple column ranges. B1 will equal a selection from B2-B15 C1 will equal a selection from C2-C15 etc. I can do this using a...

Hey all you cool excel-shark out there. I got a sheet, where i like to do a VLOOKUP from a active cell. The thing is that the active cell can change from time to time and I like the VBA-code to make a VLOOKUP from that active cell and then dragging the formula below to a certain row. How...

I have a file with drop downs. The goal is to remind users to enter a response in column K (root cause) if the option "Employee Error" is chosen from the drop down in column H (Cause). How do I make a message box appear saying "Please enter a root cause" once a user chooses "Employee Error" in...

:) Hello everyone! I need assistance in adapting the following vbscript: Option Explicit Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'check cells for desired format to trigger the calendarfrm.show routine 'otherwise exit the sub Dim DateFormats, DF...

Hi all, I have workbook that I would like to automatically hide/unhide rows & columns based on values. I have 3 activation cells on a worksheet called "Capacity Requirements". D7: The value of that cell can be 1-7 and is intended to determine the term of the model (from 2016-2022). In row...

I have created a formula by concatenating a number of cells with text. Example: ActiveCell.FormulaR1C1 = _ "=CONCATENATE(""=VLOOKUP(X3,'["",R1C24,"".csv]"",R1C24,""'!$C$2:$BA$13957,"",R[-2]C,"",FALSE)"")" Output would be...

I have a list of states in column A of workbook "Book1" and over 100 tabs of states in a second workbook "Copy of Exhibit 9". I have a macro that pulls data from each State tab (ie "ZZ CI") and copies the data into the corresponding state row in "Book1"; however, it's just the same code repeated...

I have some problems, thanks for helping me. Sub autoFill() Columns("BB:BB").Select Selection.autoFill Destination:=Columns("BB:BC"), Type:=xlFillDefault Columns("BB:BC").Select Range("BC4").Select End Sub I want to make Columns("BB:BC") as Dynamic using ActiveCell.Offset I...

After selecting the cells had to show the cell next to, but I did it traditionally wanted to made it using VBA/Macro. Can anybody help me whit that ?? This may help http://www.clo.cba.pl/klucze_1.xls

Thanks for looking at my post.. What I am trying to achive is when a cell is selected (no paticular cell) you could hit a button and theis would be inserted after what is already in the cell and the cursor would be blinking in between them.. I no this a bit odd.....

I've got a function as follows: Function VerificarInfinito(a As Double) Set c = ActiveCell ActiveSheet.ChartObjects("Planta").Activate If (a >= 3) Then ActiveChart.SeriesCollection(2).Format.Line.Transparency = 0 ActiveChart.SeriesCollection(13).Format.Line.Transparency = 0...

Greetings! The worksheets in Workbook A allows the user to enter either a number or part of a name in column C. If the entry is a number, a formula in column D does a VLookup in Workbook B to find the name. That works fine. If the user enters part of a name into column C, a VBA macro executes...

Hello, I have a worksheet of web URLS, but they are not active links. If I click into a cell and out of it the link will become active. However, I'm not sure how to do this for the entire column. Any suggestions? Is this a loop with send keys? Thanks, MattMAx