cellsn

The following code is generating an application defined/object defined error in the Set Range2 and Set Range3 lines. I have verified n = 71 and m = 13 (row numbers) on the first execution of the code. The syntax seems to be the same as in the Set Range1 line. Can you identify the problem? Thanks...

Hi all, first post. I'm an occasional excel user... Usually I can figure things out but this seemingly innocuous problem has me stumped and I can't track down a solution. I've written an accounting spreadsheet for myself. Column F is for adding bank transactions and column J tracks the bank...

I've searched and searched for an answer to this and can't find a solution. I have written a code that compares Cells on 1 row to the Cells on the row above, if they match they get deleted. I've then looped it to run through each row and then repeat the whole process 15 times. I have got it to...

Hello guys, I was looking for FIFO profit and loss calculation and despite many FIFO subjects (mostly calculating stock value), I ended up starting from scratch, which I usually avoid.. two subjects helped to understand, but I coudln't have it work for my-self. This UDF couldn't work ...

Hello guys, I was looking for FIFO profit and loss calculation and despite many FIFO subjects (mostly calculating stock value), I ended up starting from scratch, which I usually avoid.. two subjects helped to understand, but I coudln't have it work for my-self. This UDF couldn't work ...

Hi, I have a spreadsheet which has a number of formulas. The spreadsheet lists names and payments and I often have to add a high number of new rows but as the sheet is alphabetical not in one place. I have a macro which inserts and new row and copies down the formulas I need but leaves the name...

Hi, I have a spreadsheet which has a number of formulas. The spreadsheet lists names and payments and I often have to add a high number of new rows but as the sheet is alphabetical not in one place. I have a macro which inserts and new row and copies down the formulas I need but leaves the name...

Sub datatransfer() Dim j As Integer Dim k As Integer Dim n As Integer Sheets("Master").Activate sheetcounter = 2 k = 24 j = 1 Do Do Until Cells(j, 1).Value = Worksheets(sheetcounter).Cells(15, 5).Value j = j + 1 Loop n = j + 1 Do Worksheets(sheetcounter).Cells(k, 4).Value...

So... i have a sheet with a lot of lines and for each line I have between 0 and 5 information's (one in its own column) i need to spread out so only 1 column. Eksample: <tbody> Order part1 part2 par3 Numbers S001 X x 24 S009 x 10 S011 x x x 15 S115 10 </tbody> This i need to...