target cell

I am using Excel 2010 and I want that the Excel sheet will be updated (calculated) automatically when the value of a cell (<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono'...

I have code triggered to run as soon as the user enters a number in a certain range of cells. Is there a way to make it so that the cell that changed in this range is now the activecell? So for example, if column A has the formula to add columns B + C and a user makes a change to B5 - how do I...

Hello everybody, I am a beginner in vba (and this forum) and I found the Thread to create a row and input data alphabetically here: I am using Excel 2013. http://www.mrexcel.com/forum/excel-questions/347531-insert-name-alphabetically-into-column-visual-basic-applications.html :confused: The...

Hello, I am very new to VBA and desperately need help! I am trying to set up a master (source) Excel workbook that pulls from/pushes data in approximately 12 other workbooks. Whoever is using the source workbook needs to be able to: 1. Write a date into two specific cells (E10 and G10) in a...

Hi There. I want the character "#" to be added in front of a cell value when a value is entered. I have this code but it is a worksheet_sheet change event and I am not sure if that is the correct way to go about it. Thanks! Private Sub Worksheet_Change(ByVal Target As Range) Dim...

Hello. I am trying to make a code that calls different procedures depending on the ranges I select. The problem is, inside that procedures I have other Intersects to call other procedures. And it gives me errors because the target is not defined on those sub procedures. Here the code I have to...

Every time I think I know what I'm doing with Excel Solver - I surprise myself (by what I apparently don't understand . . .). I'm trying to solve for the maximum number of company store "certificates" I need to buy, up to say a maximum of $600, in order to buy the maximum number of movie...

Hello, I have a problem that I though I overcame but seems it is not the case. The original problem originated there: http://www.mrexcel.com/forum/excel-questions/681429-how-get-worksheet_selection-change-work.html Thanks to the above thread I adjusted my macro: Private Sub...

Hi everyone and thank you for taking the time to help the needy one...;-)..., I'm new to vb but I'm learning quick as I have been task to do a template for my cie. Here is my task. My sheet is as follow: a ............b ................c 1 ----header line ( wont move)------...

I have an excel document with two Sheets. Sheet One (Worklog) displays my daily work log. Column A on Sheet One lets me choose work tasks from my list on Sheet 2. Sheet 2 (List) has a list of tasks that I do each week. The task I am concerned with in the list is End Day. So in my first Sheet. I...

Hello, I am very new to VBA code. I am trying to write a macro where based on the response of a target cell, a number of rows will hide or unhide. Here is the code that I currently have, and it works. Private Sub Worksheet_Change(ByVal Target As Range) If Range("C62") = "Yes" Then...