offset data

Hi, I have created some code for doing some vlookups to auto-populate data into a spreadsheet list. Against each record, the user selects the correct value from a drop down list, then, based on the value chosen, the vlookups find the matching value from a different sheet (the ‘Hosts List’) and...

I have defined list to select rows from A8 to last value in column A (but before A100) =OFFSET(sb!$A$8;0;0;COUNTA(sb!$A$8:$A$100);1) How to do exaclty the same, but select area like: A8:C100? When I did like: =OFFSET(sb!$A$8;0;0;COUNTA(sb!$A$8:$C$100);1) it's not working.

Sub Move_CenterANDDepart() Dim rng As Range, cell As Range, del As Range Set rng = Intersect(Range("C:C"), ActiveSheet.UsedRange) For Each cell In rng If (cell.Value) = "Valid" _ Then If del Is Nothing Then Set del = cell Else: Set del = Union(del, cell)...

Hey everyone, I am working with a spreadsheet of a huge amount of data. I generated it from a .txt file by pasting the text into Word, generating a spreadsheet using space as the field separator, and pasting it into Excel. However, some fields were separated by multiple spaces, so a lot of my...