In the following code [Range("F13:G13").ClearContents] should run before Text to columns. Because the cells have data in them I get the "clear contents" window. How can I avoid this?
Thanks!
Please Login or Register to view this content.
In the following code [Range("F13:G13").ClearContents] should run before Text to columns. Because the cells have data in them I get the "clear contents" window. How can I avoid this?
Thanks!
Please Login or Register to view this content.
Last edited by sick stigma; 01-15-2011 at 06:12 PM.
Try this.
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks