extend

Hi, tried searching for this but not found it so far. I am using "ActiveCell.Offset" to select a specific cell, based on the current week number. That bit works. I then want to extend the selection from a single cell, to a range 6 columns wide, 2 rows deep, where the active cell is at the top...

Hello I am trying to figure out how to extend my selection from a single cell in Col A (active cell), downward, for as long as Col B is blank. That is, keep extending the selection downward as long as Col B is blank and to stop once an entry in Col B is encountered. The selection should not...

Heya, I've got a table that processes info from another raw data table. I have converted my processed data table in to an Excel Table Object (the one you can drag down and it copies formulas). My issue is that i have to update the raw data quite frequently and each time i have to manually...

Hi! I really hope someone can help me with this issue. I have a spreadsheet with MANY columns containing array formulas to display values from columns in another excel file. For example: {=if('file_path\file.xls'$A$2:$A$500="","",'file_path\file.xls'$A$2:$A$470}. Basically, when it would...

Hi, I been running searches for this with no luck so hopefully somebody can help. I'm trying to extend a formula down but across columns. Let me give you the example. I am in cell BL2 and want it to equal cell B10. No problem, I type "=B10". Now I want to extend the formula, but instead of the...

Dear All, I have the following code which works for 2 columns(B & C) in my excel when Column A does not exist but I want it to work for the format defined as under: <colgroup><col width="148" span="3" style="width:111pt"> </colgroup><tbody> Script # Step # Module Script 1 Step...

Hi all!, I have searched around the internet on this one and have not quite found what I am looking for yet. Would anyone know if there is a way to essentially add/extend an existing VBA call in Excel? The goal is to have the Copy function work just as normal but actually extend the built-in...

I'm using data validation on some cells, but the drop menu only shows 8 entries in the default window. If I want entries below this I have to scroll down, which is taking a lot of time for the specific task I am doing. I want to extend the drop window to show the first 20 list entries without...

Hello! If I were to build some macros for a workbook, is there any way to extend these to other workbooks? For instance, if I were to be downloading a new excel spreadsheet once a week, is there a way to have the macros already available on the new spreadsheet without having to copy them...