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
Alright, imagine I have a worksheet which looks like this:
but just with 8800 Item Numbers. The first two digits of the...
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...
Attached is my sample file..
And I have this script
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