Have tried this but getting same error...
Please Note : I am copying Pivot Table from Another Workbook into new workbook and Then I had changed Pivot Table name in new workbook and then trying to change Source Data but error occurred.
Dim Pivot_sht As Worksheet
Set Pivot_sht =...
Hi..
I want to know how to check excel file is corrupted or not..as I we are storing multiple excel file in folder but some files are corrupted.....
Thanks,
Nitesh
Hi,
How to compare 3 cells value available or not..
ie. A2 B2 C2
I want to check any if value is available or not in any one of the cell...if 3 cells are empty then highlight as red.
Thanks,
Nikh
I want to highlight cell value if not present in array..
ie. if in array("IN","US","SG")
If in Range(A2) to last row if cell value not in array then highlight cell as red backcolor.
Thanks in advance,
Nikh
Hi..,
How to stop creating backup file i.e Backup of CENTERLISTDATA.xlk
Note :- I have tried Check / unchecked Auto Receover option.
Version of Excel - 2007
MS Office Edition : Enterprise Edition
Thanks,
Nikh
Hi..,
When i download file from system its exported into .xls format and i need to convert every tie into .xlsx ...is there any vba code to this in quick...
Thanks,
nik
Hi..,
Is there any way to change messagebox design (except userform suggestion) same as like as messagebox displayed on webpage or other sites...
thanks,
Nitesh
Hi Experts,
I am looking a vba code to check latest excel file in folder and copy data into macro file and then move file into another folder...
How to do this using vba code ???
Thanks in advance..
nitesh
I have reinstalled / repaired Office but same problem....even i have checked any updates from MS......also checked ctrl + end....but same problem.....is there another issue ...
I have gone thr' this but can't get satisfied answer....i.e => How to create unique number when export mail into excel and if i received multiple mails at same time then how to handle this...
Hi..
Is there any trigger to check new mail in subfolder of inbox (i.e Inbox then subfolder "Mails FromFriends") then export sender name and subject into excel database then create unique number and send again mail to sender...
if it is possible then how can we write code for the same...
Hi Experts..,
I have Installed Excel 2016 (32 Bit) on my windows 8.1 system.....Whenever I work on small data i.e around 10 cols and 500 rows....My Excel gets Hangs and then i have only options to close workbook.....(If you press ctrl + s then excel save data but not working)...
I have checked...
Hi..
I am looking for vba code which is autobackup excel file (in background as per interval) and save in target folder. If excel get crash then when I open again excel then it should ask for recovery of temp file.
or
if my excel stops or Not responding then automatially save file & wait...
Dear Abhijeet...,
Run your macro in debug mode..i.e pressing F8...just send 2-3 mails by using F8 keys...then it will not ask you for allow/deny option.....If not then you have to turn on options as below :
Hi Abhijeeet,
change macro setting of outlook to always run macro save & exit and then run code in debug mode (F8) with ".send" ....send more than two mail in debug mode and then problem will solve....
I had same problem & now this resolved..