I want to save activated worksheet at given folder path and want to save in tab with specific worksheet name using VBA macro and want to delete activated worksheet again.as i am doing this for number of files and also i want to add wrap text =true and row height set 12.75 Tried below code
Code...
Alright, imagine I have a worksheet which looks like this:
Item No.
916.96.426
210.11.001
284.00.921
372.01.921
558.12.943
634.23.211
634.65.407
634.69.500
660.07.221
660.07.301
903.99.631
100.87.802
124.41.112
210.11.003
210.40.601
but just with 8800 Item Numbers. The first two digits of the...
Hello All,
I'm experience an issue with cells in Excel 2010 which I have Data Validation turned on for, the user's are to enter "Yes" or "No" and receive an error message if they don't to try again. I was having a pilot user run through some QA Testing on the document, and they found if they...
Hi all..
Attached is my sample file..
http://www.speedyshare.com/259873304.html
And I have this script
Sub auto_open()
DerCell = Selection.Range("A2").End(xlDown).Address
Set MyPlage = Selection.Range("A2:" & DerCell)
Dim MyDate As Date
MyDate = Now + 7
For Each Cell In MyPlage...
Can anybody tell me why this function is not working:
Function CalcValue(pVal As String) As Long
If pVal = "xy1267" Then
CalcValue = "fdsfs, dfs"
ElseIf pVal = "xy1671" Then
CalcValue = "xxx, ysdf"
ElseIf pVal = "me2742" Then
CalcValue =...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.