Creating email attachment out of excel - so close yet so far...

The following code may be causing this

Please Login or Register  to view this content.

The first range statement may not be doing what you expect. In particular the 'Selection.End(xlDown)' may yield strange results

You could try the code below (note I have also set SkipBlanks to True as this only refers to empty cells at the end of the selection)

Please Login or Register  to view this content.

Hi OllieB,

Thanks for the reply! I should clarify that I do not see a problem in the selection part of the code, I used your suggestion and the results do not vary, it really seems like I am missing something in the step between converting that selection into the .csv file.

malikazam,

under certain conditions Excels loses track of the last row actually used on a worksheet. You can check this by opening the worksheet manually, position the cursor on cell A1 and pressing {Ctrl}{Shift}{End} simultaneously. If all is well the selection shown should only encompass a range of cells that have values. If things are wrong it will select pretty much the entire worksheet. Can you check this for me.

Another solution you could try is to copy & paste the range used onto a new empty worksheet and saving that new worksheet as a CSV. That would also save you the work of removing columns, rows etc, and I am pretty sure that will solve you problem altogether.

You could try to use the below code to generate the CSV

Please Login or Register  to view this content.