-
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.
blank lines
-
R
Save CSV files without adding empty line at the end?!?
Hi all! I've got a workbook with a macro that will export my various tabs, each as separate CSV files, and save them into a specified folder. The problem I'm having is that the files get saved with a blank line at the end. In order to use the files in another system, I have to open each one in...- ramkrau
- Thread
- blank lines csv export macro vba
- Replies: 4
- Forum: Excel Questions
-
M
Macro to sort ranges in column
Hello all, I'm looking for a macro to sort ranges based on a recurring word in column W. In column W I have a word ("Wave 4") and every time I see that word, I want to sort the range based on the values in column W from big to small. And then it has to look for the next Wave 4 word and do it all...- mikey1987
- Thread
- blank lines macro sorting
- Replies: 14
- Forum: Excel Questions
-
E
Deleting blank rows and shifting rows up
Okay, this is my very first post and I might not be asking the right question but here is what i'm trying to accomplish. I'm creating a master list of projects according to employees. So I created a drop down box with employee names and then used the code:=IF('worksheet'!C:C="employee...- edrodz86
- Thread
- blank lines deleting rows drop down box shift up
- Replies: 6
- Forum: Excel Questions
-
C
Blank Lines
:eeek: I have a report that has everyother line blank. I want to delete the blank ones. I attempted to filter it and deselect "blank" but it dosen't work. Any ideas on how I can achieve this? :eeek: :confused:- Cozmo35
- Thread
- blank lines
- Replies: 4
- Forum: Excel Questions
