Solved
May 22, 2013
EXCEL VBA Timevalue format (hh:mm am/pm)
How do I set the format for timevalue for 12-hour clock without second. For example: hh:mm AM/PM. Right now I'm using Format(TimeValue(Now), "hh:mm") but…
thumb_up 14
trending_up 2
vba
81 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.
Solved
March 8, 2013
‘1004’: “The sort reference is not valid.”
I am trying to sort a range within a separate sheet. However, I keep getting this message: '1004': "The sort reference is not valid.…
thumb_up 13
trending_up 8
Solved
February 6, 2013
Office 2013 Excel .PutInClipboard is Different?
I've used a routine for years to put a plain text string into the clipboard that I can paste into another program such as:…
thumb_up 4
trending_up 8
Solved
February 6, 2013
How to call Excel VBA functions and subs using Python win32com?
My Excel workbook contains VBA subs and macros similar to those below; they sit in Module1. How to call them using Python win32com module?…
thumb_up 6
trending_up 4
Solved
January 26, 2013
Implementing String.Format() in VB6
Can String.Format() be implemented in VB6, at least a close-enough version of it that could be useful when programming in good ol' VB6? Good…
thumb_up 37
trending_up 32
Solved
January 18, 2013
Save multiple sheets to .pdf
I have a reporting spreadsheet that grabs some data from a database and forms three sheets of summary report information. I want to run…
thumb_up 34
trending_up 10
Solved
November 11, 2012
VBA-excel paste chart as a picture
I am creating various charts from the same source. I would like to be able to cut paste with vba each chart as a…
thumb_up 9
trending_up 4
Solved
September 26, 2012
Test if range exists in VBA
I have a dynamically defined named range in my excel ss that grabs data out of a table based on a start date and…
thumb_up 14
trending_up 5
Solved
September 7, 2012
VBA code to set date format for a specific column as “yyyy-mm-dd”
I have a macro which I specify the date (in mm/dd/yyyy) in a textbox and I want to set this value for column A…
thumb_up 18
trending_up 8
Solved
July 26, 2012
How to highlight selected text within excel
I would like to write a VBA function to highlight specific text within an excel cell. Is this possible? I've been googling but it's…
thumb_up 10
trending_up 2