xldown

Hello everybody, Here is my original code, which goes down column F, from F4 on-wards. It averages 5 cells at a time, the result of which it places in column G, from G4 on-wards. It uses relative values, so cell G14 will have the value of F14:18/5 and so on. Range("g4", "g250").Formula =...

<code>I am using a filter to remove unwanted clutter. I then need to fill in column G and H, but only if there is a usable row. I am having troubles with row just below the filters. If the first visible row below the filters is blank, it needs to exit the sub. Sub selectDirty()...

Hi there, I'm pulling data from FTP files and using that data to calculate a monetary balance. The FTP file has some blank cells and the xlUp function gets stuck... it doesn't really cause a problem but I would prefer to select the first cell in the sheet and find the range by using xlDown...

I have a pretty big task in mind, and I'm stuck on a lot of parts. I've outlined it below: 1. search for a specific phrase in the spreadsheet (exact phrase, match entire cell contents). Store its index. This is easy enough: Cells.Find(What:="Vendor Terminal p/n", After:=ActiveCell, LookIn:= _...

I have a loop in a macro that seems to have stopped working. This part of the macro, and the data I'm using to test the macro, have not changed since the last time I tested it, 2-3 weeks ago. All changes made to the macro take place after this part is complete. (I was trying to check something...

I'm trying to automate a report i currently create from a pivot table and then "spruce" up manually. Been working on it today and have easily managed to get all the data from my pivot table. The problem lies in the formatting. For each region i do a breakdown by surveyor of their jobs per month...

Hi, I've used the following formula many times to autofill to the last row based upon the adjacent column Range("D5").AutoFill Destination:=Range("D5", Range("D5").Offset(0, -1).End(xlDown).Offset(0, 1)) For the code i'm currently writing Column's B & C will always have gaps in their data...

Hi, looking for a way to select data, beginning at A4:C4 down to the bottom of the range but excluding the final line which will be Grand Total line. The selected data will be used to make a chart. Any ideas? Thanks Ben

Hi all,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am having trouble with a bit of code. Select the empty cells between to cells.<o:p></o:p> <o:p></o:p> Really struggling to do this. Offset moves the whole selection range! I’m guessing it...