I have a post in the Excel section and do not want to repost. I am having a problem with the objRange.FormulaArray = objExcel.Transpose(varResults). The below link brings you to a sample DB and the full post.
It works with some dates but not with others.
*Note* please hold down Shift when opening as I have a form running on startup.
Any and All help would be greatly appreciated.
http://www.excelforum.com/2649803-post1.html
Please edit the other post to refer to this to save unnecessary effort.
Alternatively, indicate which of these posts you want to have marked closed.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks