Set My_Range = ActiveSheet.Range('A1:A' & Last_Row) Find('*',, ,, xlByRows, xlPrevious).Row Find('*',, ,, xlB圜olumns, xlPrevious).Column Someone please help me figure out what I'm doing wrong? Thanks in advance! Public Sub a_SaveAsTextWithDelimiter()Ĭonst MYFILE = 'Macintosh HD/Users/darrenmason/Documents/Products/Creator NXT/Serials/' I had a working version of the script below on my windows machine, but now I'm trying to get it working in Excel 2011 for Mac.
Just to preface everything, I'm a total vb hack - as in cut/copy/paste and try to make things work.