Deleting data in a rows

Originally Posted by nekmat97

(e.g. value = 100, logical = <, data type = A), all the values lower than 100 in cells column X3 which is data type "A" are deleted, but also the row that contains this data is also deleted.

So for example, if Z100 has a value lower than 100, the whole row "100" is deleted but only from X3:AA15000.

Just for clarification, is this a typo? I thought Data Type A pertained to column X, so unsure why we'd be deleting row 100 if Z100 was less than 100 as per your example.

Might be a good idea to attach a small sample workbook so we can fully understand your data layout.

BSB