quicker

This is pretty fast, is there any quicker? Thanks. LR = [match(2,1/(l21:l<>""))]

Hi, hoping you clever people can help please. I have a long formula in a report that looks at values in a particular column that is specific to months. On the 1stof the following month I have to roll the formula forward so that each column value increases by 1 i.e. AD becomes AE, AE becomes AF...

I have a workbook with a ton of external links (Tabs JAN - DEC each with at least 100 external cell references). The workbook it's linked to changes annually. Instead of going through the LOOOOOONG process of editing the links via the DATA tab, is there a quicker way to do this? It used to...

Hi All I've recorded a macro then looped it, but it runs so slowly (takes around 45 minutes to complete). I've got a feeling it's so slow because it has to copy and pastes 12 images (barcodes) 537 times, but is there any way of using different syntax to make it quicker? Here's the code: Sub...

Hi all, A pretty simple one but in need of advice. The quickest way to populate cells P1:P25 with values 1-25. I recorded the following macro and am using that, but i am sure there is a quicker way to generate the numbers. Sub record1_25() ' ' record25 Macro ' ' Range("P1").Select...

I want to make a certain cell, (H7) to convert the letters Y or N to display the word Yes or No. Is this possible? Is it better to create a macro to do this or to use a cell formula or VBA? For example: To make filling out the spreadsheet quicker my boss just wants to type the letter "Y" in a...

Hi, when running this code to lookup criteria on just about 300 rows, excel hangs and this takes maybe 30 seconds =LOOKUP(2,1/((A9=Sheet1!A:A)*($E$1=Sheet1!E:E)),Sheet1!C:C) its to output value in Sheet1 column C where the 2 criteria match any quicker way, sure there will be thanks in advance

I'm looking to make my vba code run faster. Any suggestions? Sub ShadeAllSw() Application.EnableEvents = False Application.ScreenUpdating = False Application.Calculation = xlCalculationManual ActiveSheet.DisplayPageBreaks = False ActiveSheet.ChartObjects("Chart 3").Activate Dim DrObj Dim Pict...