specific range

Hi there, I am very raw to VBA and struggling to get my head round it. Nonetheless I am trying! Your generous help and wisdom would be greatly appreciated please. As per above, I'm creating a macro to renaming a specific array of sheets using same cell reference (E1) in each. The work book needs...

Hi all, I would like to be able to sum particular rows of data. In my first table below I have 2 columns of data. In the second table I would like to be able to enter a particular time range (e.g. 20 - 40 mins) and use a formula to get the sum of energy within this time range. What formula...

Hi guys, I would like to calculate the average power over a specified time range. I could use the average function. However, the time increments are not consistent. As you can see in the table, the time increments vary. I think that the average function would assume that each time row is...

Dear all, I have a worksheet where I read an external barcode and then I set a cell to write the same barcode as the one I have read. Well, what I need it is a code to print the specific ranges of cells ( or the whole sheet) where the barcode is written right after I read it with the scanner...

Hello, I am trying to figure out how to delete names of ranges in a specific range, using vba code. I tried this : ActiveWorkbook.Worksheets("Sheet1").Range("e6:bx2000").Names.Delete but it doesn't work. I googled it... got nothing :eeek: Please help

I have a worksheet that contains invoice numbers in column D. I'd like to copy the invoice number to another worksheet ("Details") when one is selected. I've added the "If IsNumeric" condition to make sure that only cells containing an invoice # can be copied over. The code is in the Sheet1...

Hi, I'm trying to figure out how to write a macro that will add date to a cell if you double click it. But this feature should only apply to a range of cells $C4:$E1000. The date should not change the next day when the file is opened

I have a cell (A1) in worksheetA that I would like to have = (A1) and (E1) from worksheetB concatenated and then I want (A2) in workbookA to do the same with the next cell in column A worksheetB that has text. Is this possible? i can get it to concatenate but i am not sure on how to autofill...