Sub delete()
Sheets("866").Select
Dim fee1 As Integer
Dim fee2 As Integer
Dim fee3 As Integer
Dim fee4 As Integer
Dim fee5 As Integer
Dim c As Range
fee1 = Sheets("Sheet1").Range("a1").Value
fee1 = Sheets("Sheet1").Range("a2").Value
fee1 = Sheets("Sheet1").Range("a3").Value
fee1 =...
Hi,
I'm having trouble deleting rows based on a certian criteria. I have two sheets in workbook. One has a list of all the diferent criteria I need and the other sheet has a tonnes of rows of data. I want to delete all the rows which don't have the crietia from the first sheet. The criteria...
Thanks!
I made the change and now the code doesn't produce any errors...but it still doensn't select the whole range. Only the first row gets copied and pasted...is there a way around that?
Hey I'm trying to create a macro which searches for a certain range and then copies and pastes it into a new sheet. The problem i'm having is finding and defining the range. The range starts with a portfolio code and end with that same portfolio code; and I want to select everything in between...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.