Hi All,
i searched many posts but all of them seem to be for different cases.
i have sheet where i am pasting raw data table from column BA to CA
my data has random blank cells in column BY
i want to make macro to delete the range BA##:CA## where BY cell is blank
(i dont want to delete the whole row because i have other data in the rest of the columns A:AZ)
tried many examples but cant seem to be able to find proper way to delete only the range
can you help me on this?
Bookmarks