call

Morning everyone. I've arranged a bit of code that filters my workbook, selects a named range, copies that range as a picture, opens up a new email on Lotus Notes (unfortunately), pastes that pitcure in the email's body, along with various other text as well as grabbing recipiants and a subject...

Hi all, Apologies, I've been doing some reading and little out of my depth. I'm trying to convert the below code to work with worksheet_deactivate() command (when leaving a worksheet "Rebate Conditions"), however not having any luck. It works as a macro in a button on the sheet, just not when...

Hi there, I have a large data set from an export of phone system. In the data set there is data i can pivot tabel to find my results but the format isnt conducive to pivot without some modifications. I need to find the "DNIS:" in column A and also the information in Column B and add the type to...

I have set up a userform with tabs that filter 4 list boxes, user can make multiple selections in each list box and I would like to further filter subsequent listboxes by the previous one. Then when user makes all the selections it auto filters a spreadsheet leaving the first 2 rows above data...

Hello, Need help in the below code. I am calling a command button sub procedure using the loop. When I did it without loop I used Sheet3.CommandButton3_Click and it worked fine. But, then I am doing it using loop then I change it to ActiveSheet.CommandButton3_Click which is throwing error...

Hi, I have a macro that build PowerPoint presentation from excel. And workbook that has several tabs and their names as below: "It would take", "Themes_2", "Themes_1". When I tried to build the slides this is what happened: "It would take" tab successfully built into .pptx but the rest of the...

Hi all: I want to have macro that Call al ot of Sub/Functions with conditions: Left(ws.name,4) = "AAA0" and ws.range("A2").value <> 0 When conditions match will Call Sub Filter_ & ws.name For example: if ws.name = "AAA012345" and sheets("AAA012345").range("A2") <>0 then Call Filter_AAA012345 I...

Afternoon everyone, I hope you're well. Got a slight problem I'm trying to get my head around and was wondering if someone could help. I've got a bit of code that goes to a named range, inserts a row and copies the format and formula from the row above: Sub AddRowS1()...

Hi everyone, Looking for a code that will populate e-mail drafts within outlook, but not send them out, based on information within a table. The table name is Email_Table, and the sheet is Sheet1. Specifically, what I need to populate within the e-mail is: 1) The subject which is in cell B1...

Hello, I have a two dropdown based cells (C4 and C23) that have some values. Based on the selected dropdown condition, I need to hide/ unhide certain rows in another sheet (written macros for it). I'm using the following code, but only one works at a time. Could you please help as I'm stuck...

I have code that fluff was kind enough to help me with. It works as written, but when I added a call code, it would provide the following message multiple times "Check to verify veteran data is entered in FY ## REFERALS." "It's critical that the veteran data is captured." It didoes not matter if...

Hello, I am trying to have contents in a cell in column 9 (Column I) to delete once the user selects SUBMITTED from a in cell drop down list over in column L. Once the user selects SUBMITTED it needs to delete the contents in Column I or 9 on that same row. I have this working for when it calls...

I am trying to make timecards that update from a master list. First worksheet - master list with rows of info (name, acct code, time in, etc) Second worksheet - timecard template (cells call upon info in the master list) I can make sequential worksheets based on a list (column A), but I...

Hi Everyone, I need your assistance with an issue I'm having with the following lines in my "ThisWorkbook" code. I introduced the following codes into Private Sub Workbook_Activate() Private Sub Workbook_Activate() Application.EnableEvents = False Application.CutCopyMode = False .. .... ..... I...

Hi, In .xlam file I have added UserForm which initialize by set position of the form in middle on main screen with dual monitors. I am using it commonly in all other forms in xls/xlsm. Me.StartUpPosition = 0 Me.Left = Application.Left + (0.5 * Application.Width) - (0.5 * Me.Width) Me.Top =...

I'd like to extract the numeric values after "PW" but before any non-numeric values. I've tried EXTRACTNUMBERS(MID(F2,find("PW",F2)+2,6), but I'm picking up extraneous numbers. Example: Tested PW31 Call re: PW6798 Reviewed info PW64167/2 Updated PW 1,2,41 Desired Output: 31 678 64167 1 Thanks!

Dear Friends, i have data on "ACC" sheet. i need to import all rows between B:E which has "X" on F column & "AA" on G column to another sheet COL A1. Thank you in advance. https://docs.google.com/<wbr>spreadsheets/d/<wbr>1liq67JfknmHSdtjJWM4n_<wbr>UyjUFWDMY3t4VTyYLzxydE/edit?<wbr>usp=sharing

My first post - I'm new to VBA. My workbook has about 20 worksheets. I would like to get input from the user that will then call macros to print specific sheets. I've got the print macros working correctly but I keep getting Run-timer error 424 - Object required errors when I take the input...

Hello All; I have a log that users will be adjusting data based off statuses of Drawings. Starting at A11, B11 & C11: Column A is DRW NO., Column B is DRW Description and Column C is Location/Rm. Over in Column L is the status column where the user will select from drop down list. I have this...

Still trying to get my head round VBA, would appreciate the help hear If Worksheet Call Log, cell F has Mitch entered Copy and paste to next blank row Worksheet Bid Log, Cell C = Worksheet Call Log cell D Cell D = Worksheet Call Log cell E Cell E = Worksheet Call Log cell F Cell F = Worksheet...