creates

Hello! Why dragging =COLUMNS($C$11:C11) from C11 does not create a sequence of 1,2,3,.. but instead creates 1,1,1,..? thanks!

Hi there, below is the code I have in the excel file. Basically what it does it starts with one tab full of data, creates 3 new tabs, and then filter/copy/paste information from the original data set to each of the 3 new tabs based upon different attributes. It also adds a new "date" column to...

Hello , I am looking for a VBA program that creates a sequence of numbers with prefix "NLk" in Row A in the cell one after one Ex : NLk000001 After creating the above number , I would like Have a VBA that creates a folder in the system with that number ( Ex : D:\ Data\D...

Hi, I am trying to convert formulas to .formula in VBA. However, I found it hard sometimes. Is it possible to convert a subroutine that creates .formula from formulas? An easy example would be: =SUM(A2:A5) get converted to .Formula = "=SUM(A2:A5)"

Hi. Anyone have any idea why... This array formula "spills", or creates 3 values: $A$1:(A1:A3) However, wrapping it in ROWS does not spill (or creates a simple value of 3): ROWS($A$1:(A1:A3))

I need to do this in excel with vba for school. Create a subroutine Factorial(n) that creates an array of size n. The first element ofthe array is 1. The next element is 1*2. Next is 1*2*3, etc. Formula: for n>1, ifelement ‘n’ is x then Xn = Xn-1 * n. For example, Factorial(6) creates this...

Hi I am new to this message board, but I am using power Query it creates a new table when I merge and upend data. For example I upended three tables with ~50,000 lines each so I have the original files and the upended the file (that's fine) then I start merging in data and as I do it creates a...

Does anyone know which add-in creates names with a _bdm. prefix? An example: _bdm.8967E1C0A2914A6EB0F4E56B3B28F0A2.edm

Hi, Trying to add all of occurrences of "Yes" in a particular range for all worksheets. I was hoping to use the clever trick I use for summing across worksheets: =SUM(First:Last!$E$36:$I$36) I tried using COUNTIF or AGGREGATE (using 2 for COUNT) but I get #VALUE ! error...

Hi Folks, I have a macro that my team run that creates a workbook with lots of worksheets. We need to be able to separate out those worksheets into separate files as part of the macro. I did find this online but it separates out the sheets in the workbook the macro is run from and not the...

I have the following bit of code that simply creates sheets from a list in column D on my sheet called 'List'. This all works perfectly with one exception. When the list includes a new sheet name that already exists, the code creates sheets called 'Duplicate 1', 'Duplicate 2', etc...

Hello everyone. I'd like to create a macro that creates a word document that contains the contents of cells that I specify. Can you suggest any articles or code for me to get started. Please keep in mind that I am far from being a VBA expert. I know enough to read the code and understand...

Hey all, I've created a VBA which at the end creates about 30-50 files which I wish to password protect. Easy enough, but what I want to do is be able to have the current month as part of the password automatically. So for example today the password will be PasswordJanuary or Password01 and...

Hi, I have the code below which creates a file from every worksheet in my workbook. It works fine however it doesn't preserve any cell merging when it creates the new files - the merging is lost in the new files. Is there some code that I can add into this routine so any cell merging is...

Howdy folks, So this is my dilemma....I have 2000+ rows of information and A-T columns. I am trying to simply insert information into column O line 176 without disturbing any of the columns/rows to the left...Is there a way to do this? I have tried inserting but it always creates a blank cell...

I am trying to put together the code in MS 360 Excel that will allow me to turn a single cells red if the macro creates an error. Here is my current Code which doesn't work. Validate that any new accounts For i = 6 To FinalRow - 1 Cells(i, 9).FormulaR1C1 =...