xldown

  1. P

    A Range that'll Change

    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 =...
  2. Z

    end sub when next visible cell is empty. Compile error: Block If Without End If

    <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()...
  3. P

    xlDown won't select lastRow, help selection lastRow w/o using xlUp

    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...
  4. D

    Do While and 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:= _...
  5. K

    Loop stopped working: Selection.End(xlDown).Select

    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...
  6. B

    Select between two bold cells

    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...
  7. B

    Autofill xldown offset three columns

    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...
  8. B

    Select Data xlDown -1 VBA

    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
  9. melewie

    XLdown then up 1 !!!

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top