false

How can I disable gridline in the create temp file to send to outlook vba? Sub Send_Email() Dim Email_Subject, Email_Send_From, Email_Body As String, i As Integer Dim Mail_Object, nameList As String, o As Variant, ws As Worksheet, ws1 As Worksheet With Application .ScreenUpdating =...

Hi all, Need some help adding some coding to loop through tabs in another workbook. The code opens up a file(s) in a specific folder and the aim is to just copy all data in all tabs into one tab within DataDump file. Sub Execute_Files()Dim objFSO As Object, objFolder As Object, objFile As...

Hi, I have the below coding which works fine but instead of referring to the sheet named "Cordis", I would like it to get the sheet name from cell A12 (which has "Cordis" typed in it). Private Sub CommandButton1_Click() Application.ScreenUpdating = False Sheets("Monthly Data").Select CleanUp...

Hi Everyone, I need some help, I have a document with 3 tabs that are always there and weekly tabs that get added now the 3 tabs are "Template", "Todo List", and Historic. now the other tabs are all the same and get created from the "Template" tab but I never know what they will be called or...

i have a code to consolidate the all sheet into one. sheet name is consolidate. but whenever i have running this, data copying twice. :( Private Sub CommandButton1_Click() Application.ScreenUpdating = False Application.DisplayAlerts = False Sheets("One").Range("a1:c1").Copy...

Dear Guys Hi i am having the following problem with below vba codes when saving file to xls and pdf Error Run time Error 1004. Document not saved. The document may be open , or an error may have been encountered when saving. My vba codes are as follows :- Sub searches() Range("b2") =...

I ma trying to set my project so that when my userform is open, I can still select and edit cells. I have tried setting the model to false and using vbmodeless but when I do that the form just blinks and goes away. Any ideas?

Hi all, my whole code extract is below and the highlighted bold red parts are giving me grief. Suddenly, last week, out of the blue, this error started cropping up. I need to determine whether a tour type is Coach, Rail, Air or Self Drive. I make this determination near the start of the code...

How do I successfully nest multiple AND and OR's along the same row? For example, I want to check if K3=V AND AP3 or AR3 or AT3 or AV3 or AX3 or AZ3 or BB3 or BD3 or BF3 or BH3="L" then TRUE, otherwise FALSE. I tried but failed spectacularly.

HI i hope you can help me with the code below as this is not working an i am trying to update a cell in a sheet called 'Data' if changes are made in my userform, my range in the 'Data' sheet my range is A1:R17 , ROWS B1:R1 have dates inand columns A2:A17 have areas in, then B2:R17 have numbers...

I am not even sure if this is possible or not, but here it goes. I have two spreadsheets. Each spreadsheet lists a bunch of parts and part numbers. Spreadsheet A is the database of existing parts in the system. Spreadsheet B is a list of parts from a batch. In Spreadsheet B I want to be able...

Hi I have some code (below) that I use to send a Named Range via the MailEnvelope function of Excel. It was working for a while but now, when I run the macro to send the e-mail, everything works up to .Send. There are no crashes or error messages but it doesn't send. Before, you would see...

Please consider this userform initialization code. Private Sub UserForm_Initialize() 'Hide frames F1_WCF.Visible = False F2_WCA.Visible = False F3_WCO.Visible = False F4_CCF.Visible = False F5_CCA.Visible = False F6_CCO.Visible = False F7_PTD.Visible = False...

Dear Team, I am using the mentioned vba code to find text in font color red in powerpoint . The below mentioned code i was using to find red color font text in ms word. Sub newred() Selection.Find.ClearFormatting Selection.Find.Font.Color = wdColorRed With Selection.Find...

Hello, I believe I am looking for a very simple VBA code but am not sure because of how my current Macro is structured. During one point while my macro is running it checks a certain cell (B16) and if it is blank it will issue a message, "No Results" and will end sub. If there is results it...

Checking a outside model that I received and the if statement false value is referencing the cell in which the formula is being written. If I try to recreate this, I obviously get zero, which is not the value the cell in the model is returning when the logic is false. My question is, how is an...

I have put together a VB script to refresh all excel files in a folder without opening them. The issue I am facing is that the excel files close before allowing the data to be refreshed. Is there any way to force the VB Script to wait till the data is refreshing and then save the file? Also, I...

Hello I have an Excel spreadsheet that will be used for data entry without userforms (to allow for Mac users). I intend on password protecting it to make data entry easier. It works as I hope however I found the code on the internet and whilst it works I don't quite understand one line of code...

Hi all, I have a worksheet that has multiple sheets of data, and i want to consolidate the data into 1 page of unique values. I have this code written but want to shorten it by using some loops for the copying and pasting. What my code does: 1) copies data from column "Project Name" and...

Hello, I have the below code that used to run fine but now it seems to be getting hung up and excel now freezes and the macro does not complete. Any idea what could be causing this? Thank you Application.ScreenUpdating = False Application.Calculation = xlCalculationManual...