this works for 2010 only...can anybody help me with this in 2007??
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
Type: Posts; User: SP69
this works for 2010 only...can anybody help me with this in 2007??
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
got that by myself.... its the activecell.displayformat.interior.color
VBA: Need to get color of cell with conditional formatting. Tried post by Rick Rothstein in the forum but it didn't work. I referred to :
...
Sorry if my question was not self explanatory.
I have a windows folder in which 150 mails are saved as outlook messages("*.msg").
I need to browse all and open them one by one and then download...
hi,
I have 150 outlook mails saved in a folder, each having an attachment. I want to download attachment from all to a folder, via VBA.
Please Help me with that.
I want to freeze panes but dont want to activate sheet i.e. in common i use activewindow.freezepanes method but that require sheet to be activated.
any alternate to that??
Hi,
I am having workbook with 10-12 sheets, each containing 3-4 charts. I have chart name but not the associated sheet name. Do we have a direct function to find the worksheet name associated with...