type

Hi everybody! Is possible defining a variable type array with other variable type string? Dim strLinhas As Variant strLinhas = Array(strLstSemBdo) strLstSemBdo is a variable maked from a loop, selecting rows numbers. Her can be: 52, 67, 130, 137, 155, 279, 370, 402, 417, 421, 423...

I don't see "Stocks" on the Data menu. I understand that the Stocks data type is only available to Office 365. I'm not 100% sure if I'm running Office 365 or not. I go to File --> Account --> About Excel, and it says "Microsoft Excel for Office 365 MSO (16.0.10730.20264) 32-bit". Is this not...

Hi All, I just need a VBA code to Change Pivot Cache. this code should work with any type of excel Version Thanks Nasmin

Hi all! I have a UDF that I utilise when I need to repetitively copy/paste multiple data ranges between two excel workbooks. Sub ACopyPasta(CopyBook As Workbook, CopySheet As String, CopyRange As String, PasteBook As Workbook, PasteSheet As String, PasteRange As String, Optional transpose As...

I am trying to get my userform to populate with data from a worksheet "Project Master" based on a Combobox selection "CmbFindProject". The form populates fine apart from 1 set of data. This data is a list of Meeting types and dates. There is currently 1 Combobox "ComboBox1" and 2 textboxes...

Hi all... is there a formula that would return TRUE if the date in a cell is in Current year? For example, in A1, i type in the date... I would like B1 to say "TRUE" or "Current Year" Thanks in advance!

Why is my VBA Excel editor not autocompleting while I type the code? For example: if I type "Selection". I'll usually expect to see the list of things I can do with it. Maybe I disabled any setting? Thanks

Hello, I am trying to scrape some stock data from yahoo finance with a dynamic URL, I am using if/elseif statements based on the exchange because I am pulling data from stocks listed on different exchanges so based on that the URL changes. I am using if/elseif commands to create the conditions...

Hi – new to the forum and (fairly) new to Power Query. I have managed to get the basics down (I think), and just started trying to tinker with the Advanced options. What I have been trying to do is download a file, based on whether or not a value on aseparate table is True/False, if it is true...

Hello! Someone please help! I think my issue is most likely a syntax issue but I need to pass parameters to yahoo finance to scrape the data for different tickers on different exchanges. To simplify my problem i just created a seperate test Sub to show my problem. I created 2 string...

Hi All, I have created one invoice template, different users will use this invoice template for inventory management as well. We have given selection Sale / Purchase so that transactions can be identified. I am looking for VBA which will copy entire details updated in Invoice and paste in...

I want a cell to calculate a value (in one cell) x rate (in another cell) unless: I type text or a number directly into the cell. I want to be able to overwrite the cell formula as long as I type something in, but for the formula to come back and apply if I thereafter delete its contents...

Hello, What I am looking for is vlookup type function that will look up the first 3 columns in data worksheet 1 and find it in the data lookup table and find the pay grade and if it is there return the Role Type to Data Sheet 1 Role Type. Data Worksheet 1 (8k rows) Division Name...

Hey folks, Is this possible? I want a particular word to be replaced by a different word in the same cell as it's written in. Example: If someone in cell A1 types "Apples" I want the text automatically change to "Fruits". I've tried Conditional formatting and Data validation without success...

Hi all I have the following formula =IF(P44>5,"",1) which is looking up a formula in cell P44 of =WEEKDAY(O40,2). Now when i get a #VALUE error I have tried to use the formula =IF(ISERROR((P44>5,"",1)),"", 1) but i get a message box saying "There's a problem with this formula Not trying to...

Hi, I am running into an issue that I need your help on. What I'd like to have is retrieving the first value of identical values in one range, see my example range below: x y z y z Now what I want is an index match type of function with which I can select that I want the first ''y'' of this...

Error: "The value you entered isn't valid for this field" The combo box, where I get this message, is a bound field to a table. The Field on the table is tied to an ODBC table. In the Data Type, for this field, I used the Lookup Wizard to create the list. But what is happening is that the...

Hi Guys, I've been trying to roundup the result of this formula but i can't seem to make it work. Can anybody please help me. =IF($B8="","",(VLOOKUP($B8,'Type D Box Col Data '!$C$4:$H$260,5,0)*2)+1+(2*C8)+2) Thanks in advance, bnkyaong.

Hello all, I am new in the macro and VBA world, i work to perfect myself in this new Learning. I have a spreasheet to work on and i need a code that can do this ... If anyone can help me doing it please. I have a spreadsheet that as 3 type of workers ( 43, 48 and 65)(same column A.) I have...

Hi! I encountered a strange bug. I tried to create drop down list from a set of time series (00:01, 00:02, 00:03, 00:04, 00:05, 00:06, etc.) which is working fine until I type each time value in the cells manually. BUT when I try to drag down to fill in as a series, the data validation does not...