call

Where ws is a worksheet and LR is the last row, I am trying to add a hyperlink to another location (asheet.cel.Address). The text to display is an array of data that I am trying to find. When I run this, however, I get invalid call or argument error. Any ideas? With ws...

Hello every one Kindly guide can we send a pic from excel via whatsapp I have below vba code but its can send only text through whatsapp kindly support Dim text As String Dim contact As String text = Range("C1").Value If text = "" Then MsgBox "Enter the Message to be sent!", 64, "PROCEDURE...

Hi Everyone, I installed Excel 2013 on my PC. and made the excel workbook with VBA in it. It is now perfectly running. When I went for work and used my newly made excel workbook. it started having many problems in our office we use Excel Office 365. the Error I am having is...

Support is requested to guide , Can we send excel range screenshot to any one via whatsapp . i have below mention code but its send only text . i need to send picture which available in cell range or get screen shot of range Dim text As String Dim contact As String text = Range("C1").Value...

Hi I have a activex control button. I have this code assigned to it: Private Sub Steg1Ext_button_Click() Call imghidd End Sub I have also tried removing Call and only have imghidd Then i have a module called step1 In that module i have this code Sub imghidd() extinstr1_label.Visible = True...

I have a worksheet that when a user completes they click on a button and the data is copied, pasted, and all the fields reset to blank except the DatePicker is there something I can do to call the DatePicker to reset itself back to 1/1/2019? I've been looking all over and I have found examples...

Hello, I have a worksheet selection change event code which is basically the same code copied 21 times with the only difference being the row number. Each row on the worksheet is for a different student. I am getting a "procedure too large" error and need to shorten the codes. The code...

Hello all, The title pretty much says it all but i have a list of macros that i want to correlate to a userform using the tick boxes, but for the life of me i don't understand the userform part of VBA. Can someone help me create a userform that will compile a list of macros to call? lets say...

Hi I have the following code getting data from text files and then performs calculations in my workbook. However, this code takes like 35 minutes to run. Is there any way to decrease the time? As you can see, I have the same dropbox directory but with different users, is this something that can...

Hello, I use a macro to send emails with an attached picture via Lotus Notes. The macro is working well but I need to change it so the mail appears to have been sent from a different address than mine. In a different macro I was able to achieve that by adding the following lines. They persuade...

Hello all, I'm not terribly experienced in macros, but I'm learning as I go. Any help is appreciated. I have a workbook with many worksheets inside it. From a master worksheet, I'd like my staff to be able to select which worksheets to print by selecting them with checkboxes. I have a macro...

So I run a group of called macros and I have an error handler in the "update SOS" macro, what I want to figure out is how to do an error handler which will terminate the whole macro bundle if "No" is selected. I currently have a message box to inform the user the SOS is not being updated but...

Here is my code Sub RunEight() Call ThisWorkbook.formulaXXX Call result1 Call ThisWorkbook.formulaXXX Call result2 Call ThisWorkbook.formulaXXX Call result3 Call ThisWorkbook.formulaXXX Call result4 End Sub After result4 is finished, AF22 will have a value. Unless the number is less than 2...

I thought this was straightforward but it does not seem to be. I have a two spreadsheets and in one (call it S1) I get a calculated value in column C. In the other (call it S2), I want to link to the values in column C. If, in S2 B10, there is a reference =S1!C10, and I sort S1, how do I...

Hi There's something in my below code that causes the workbook to hang either during or immediately after the named procedures run and I strongly suspect the cause is either in the first or last 4 rows. Private Sub Worksheet_Change(ByVal Target As Range) CALC = Application.Calculation...

Hello, I'm having a code structure issue, so the code below is just representative of the problem. I have several sheets which I would like to have a SelectionChange Event trigger some code to run. There is one routine that I have that needs to run regardless of which SelectionChange event...

Hi, Hope you might be able to help with this one. The formula I need to come up with is for Column E. Column A and B give a list of all prefixes and their corresponding work type. This could be considered a 'legend' for the formula to lookup from. Column D is freehand manually typed text...

Hi The below runs with a Workbook Open event to allow VBA to modify a protected sheet without unprotecting the sheet: Private Sub Workbook_Open() With ThisWorkbook Call UnprotectWorksheet(wks:=.Sheets("Training Log")) Call ProtectWorksheet(wks:=.Sheets("Training Log")) End With I...

Hi all, Thanks to some super coding by member Yongle I have been able to call a macro based on comparing two time values in adjacent cells. However, I now realise that running it after workbook open means I cannot change the static value in cell DD2 and get a new comparison with the running...

Sub opensezAme(sPATH, sDrive As String) Dim TPATH As Object Set TPATH = CreateObject("WScript.Network") On Error Resume Next TPATH.MapNetworkDrive sPATH, sDrive End Sub ------------------------------------------------------ Sub closesezAme(sDrive As...