define

Hi, I have a requirement in my formula that certain strings gets repeated. I want to put that string as a defined name. Here is an example of such string: " One"," Two"," Three"," Four"," Five"," Six"," Seven"," Eight"," Nine"," Ten"," Eleven"," Twelve"," Thirteen"," Fourteen"," Fifteen","...

Hi, For the life of me this doesnt work, any ideas? Many thanks Sub Clear_Estimated_Hours() Dim Msg, Style, Title, Help, Ctxt, Response, MyString Msg = "Do you want to continue ?" ' Define message. Style = vbYesNo + vbCritical + vbDefaultButton2 ' Define buttons. Title = "Delete...

Hello All -- In a user form I define a PDF file and it is created successfully. In a seperate module, I define another PDF file and it too is created successfully and attahced to an outlook mail. I want both PDF's to attach to the mail but have been unsuccessful in doing so thus far. Code...

I am trying to rename a picture that I just pasted (a copied screenshot) so that way I can consistently copy and paste and modify using the same name. So far the code I have is this: Application.SendKeys "({1068})", True DoEvents Dim PicName As Variant PicName = "Cinco Bug All Screenshot1"...

Hello, i need some coding in VBA which can define this workbook & active workbook in any example. Thanks Amit

I am writing coding for a rather large macro and I am trying to decrease the number of characters I use. One way to do this is to define a variable for the long file path name but it is not liking it. My coding is: ' Ask user for the period of the projection exercise PNumber =...

Hi I did google search to find out why in VBA dim keyword is used. What does that mean? I know it means Dimension, but why that keyboard? Is not easier to define a variable like this: int x (like Java) Or x as int (actually this is used when you define a custom function argument in vba) I...

Sub DynamicWebPage() ' here I define elemnts for the loop Dim sht As Worksheet Set sht = ThisWorkbook.Sheets("Sheet2") Dim LastRow As Long Dim i As Long LastRow = sht.Cells(sht.Rows.Count, "D").End(xlUp).Row ' here I define Internet Explorer Dim IE As Object Dim Doc As HTMLDocument Set IE =...

Hi In this article https://docs.microsoft.com/en-us/office/vba/api/excel.workbook.saveas MS define SaveAs as a method!! While object browser in VBA editor define it as Sub? Which one is the correct one? or it does not matter? Thank you very much.

Hi, How do I define a list using the cube function in excel? eg Say I have A, B, C, D, E, and I want to create and retrieve data for A+B only from the cube? Thanks

here is what I have right now Function FILTERIF(select_range As range, select_column, select_row As Integer, criteria_column1 As Integer, criteria1 As String, Optional criteria_column2 As Integer, Optional criteria2 As String)Dim rows As Integer Dim i As Integer rows = select_range.rows.Count...

I have read that it is useful to define a variable taking on integer values as "Long". Yet most examples I see define such a variable as "Integer" which, of course, it is. Can you provide clarification or the thinking behind an integer being defined as "Long"? Thanks, Kerry

I have the following code ShowDateBox: IPrompt = "PLEASE ENTER DATE FOR THIS REPORT:" _ & Chr(13) & Chr(10) & Chr(13) & Chr(10) _ & "(Normally Accounting MONTH END date)" IDeflt = Format(Range(InsImpDate).Value, "dd/mm/yy") ' Define buttons...

Hello, I am looking to define an efficient way to define these number of variables. Dim sumCol31 As Long, sumCol32 As Long, sumCol33 As Long, sumCol34 As Long, sumCol35 As Long, sumCol36 As Long, sumCol37 As Long, sumCol38 As Long Dim sumCol39 As Long, sumCol40 As Long, sumCol41 As Long...

want to define variables for the full destination of my current workbook, current sheet and current cell. The variable should be called: cworkbook csheet ccell

Hi Excel define Bold as a variant. Yet the example below (from https://docs.microsoft.com/en-us/office/vba/api/excel.font.bold) Assigned True to Bold!! So why excel did not define Bold as a Boolean? It would make sense to be define as Boolean. Thank you. what does it mean a variant variable...

Hi Using Object browser, Application class has the following: Activecell as range Activechart as chart Activesheet as object Activeworkbook as workbook ActiveWindow as winodw All of them make sense to me except ActiveSheet? Why is define as Object? What does that mean? Why they did not...

Hi guys Any way to prevent "Personal views" on Excel? My workteam have 15 people working on several Shared Workbooks and all users have Office Professional Plus 2016 on W10.. I have defined that all files have the freeze pane at "C2", but there are some people that insists on unfreeze...

Hi, Is there a way to define the Criteria1:=Array so that it shows all items except the ones you define? So how would i define the array if i wanted to show all values except Apple, Oranges, Pears? Thanks!

Hello All- I want to count all the "Yes", in a data range define as "CPR_Data", using the SubTotal function. Can anyone help?