activecell reference

I am building an application form in excel, whereas the applicant will only be able to edit unprotected cells. I have included coding so that the number of applicants, number of facilities, and number of collateral accounts can be populated to the correct spacing in the form. For example, I...

Hi, I am attempting to create a table where costs can be calculated by the user. These are spread into different categories. I have created a macro using relative reference and assigned this to a button which allows a new line to be entered into the table every time the button is pressed but...

Hi guys, I’ve been insanely looking for this on the web, but couldn’t find anything that would make me get why this is not working. I’m new to VBA and my knowledge is very limited, for most things I use the “record macro” option to get the code and just paste it where I need it to be on my...

Hi Folks I'm looking for the solution to the following. I want to select a range/selection that is from the active (selected) cell to the last (used) cell in that column (discontining range!) So I'm in need of something like: Range(ActiveCell, Range("D1048576").End(xlUp)).Select where D...

I'm attempting to modify a small sub that hides columns based on a key string in the header. I'm getting hung up on two points 1) passing the row number of the header and 2) setting the location of the activecell as the default header location. Here's a failing attempt. Sub...

Hello, I am trying to apply Conditional formatting using VBA from an active cell location. I can't get it working no matter what I do. I think I've narrowed down the problem to the bolded parts. If I have an actual cell address (C19) I can get it to work for a range starting with C19. I...

Hi ... I'm new to this forum - thanks in advance for taking the time to help me with this ... I'm creating a Macro to paste a series of formulas from a template in hidden rows above to cells further down in the same worksheet. My code works fine if I set an absolute range as the Destination -...