lngrows

Hi Guys, I have selected DIm Ingrows As Long and set it up as Range ("C2:C" & lngrows & ",D2:D" & lngrows & ",E2:E" & lngrows & ",F2:F" & lngrows & ",G2:G" & lngrows & ",H2:H" & lngrows & ",I2:I" & Ingrows & ",J2:J").Select Selection.Copy some how it does not work :( most probably i am...

I have a table on a sheet. The table (called TBL_Data) has three columns. The table is assigned to a ListObject object, called loData. The problem I seem to be having is that when I loop through the items in the table I am finding that the lr.Range appears to be skipping a row. Dim...

Hi, I am very new to VBA, hence the question is quite basic. However, after browsing forums, i could not tackle it myself. I was doing some modifications to the below part of a SUB. It extracts information from one sheet as per the first row and should make the ''desired output''. I have the...

I am trying to delete a row if it HAS a red color in Column C AND if it DOESN'T have the words PO box in Column N. I have gotten it to where it deletes the rows that DO have po box in N but I can't seem to get it to go the other way and KEEP the rows with po box. Here is my code. The 13551615 is...