-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
lngmyrow
-
Slightly Modify VBA Code that deletes Dups
i need to modify this code because the data has changed with respect to column location. previously the pertinent data was in B & C It is now in C & E I think changing it is straight forward except for this part "lngLastRow = Range("B:C")" Any help is appreciated! Sub Delete_Duplicates()...- gheyman
- Thread
- dim end lngmyrow part rngdelrange
- Replies: 3
- Forum: Excel Questions
-
C
Having a few issues....
Hi all, It's been a while since I did any VBA stuff. I have the code below and it does work, however I want the data to start on Row 4 on the spreadsheet. Currently it only goes for the first available blank line which is no good for the purpose. Any ideas? Any help is appreciated Sub...- cweggleto81
- Thread
- dim end lngmyrow set strfoldername
- Replies: 3
- Forum: Excel Questions
-
E
Help fixing this simple cut and paste macro
Could you please help me fix this? I'm trying to use this code to cut and paste chunks of info (67 rows long) from column A of my sheet and setting it to start in F6. It's off a bit somehow, as it is not reliably cutting the info at the 67th row. I need it to cut 67 rows, then the next 67 rows...- exceldata
- Thread
- column dim intstep lngcoloutput lngmyrow
- Replies: 3
- Forum: Excel Questions
