var

If I have 5 arrays that have same dimension, can I combine them into one array with 5 subarrays. va = ws1.Range("A2", ws1.Cells(Rows.Count, "A").End(xlUp)).Value vb = ws1.Range("D2", ws1.Cells(Rows.Count, "D").End(xlUp)).Value vc = ws1.Range("F2", ws1.Cells(Rows.Count...

Hello All, Could you please help me with below issue. I have to check each recipient's email ID in the To, CC & BCC and validate if domain falls under @gmail then it should add Confidential in front of subject line to encrypt it, however if its any other domain. it shouldn't add Confidential...

Hey Guys, I really need help with the below code. I have data in column F and it is divided in Columns A:D. I want the macro to stop when the cell value in F= "n/a". I get the Object required error message when I run the code.... Sub NameSplit() Dim var As Variant Dim rw As Long, i As Long...

Hi Folks. I trade stocks. I just created a macro in a "template" file called CIA Trade Blotter Template.xlsm to paste value the trade date from a range that contains "today()" and then save the file (downgrading it to xlsx) with a datestamp appended to the filename [i.e. CIA Trade Blotter...

I have a (model portfolio) macro enabled workbook with 3 company-focused sheets and 2 client-focused sheets. When changes are made to the portfolios on sheets 1-3 they flow to the nicely formatted sheets 4 and 5 via cell and name references. Then I ... 1) copy the last 2 sheets into a new...

I am trying to total project amounts that we have "WON" On tab BID STATUS in column "D" I have the salesperson ID "FRE102". In column "F" I have the status "WON, LOST or WAITING" and in column "G" I have the $ value. On the TOTALS tab I have a cell I want to give me each salespersons total is...

I am trying to total project amounts that we have "WON" On tab BID STATUS in column "D" I have the salesperson ID "FRE102". In column "F" I have the status "WON, LOST or WAITING" and in column "G" I have the $ value. On the TOTALS tab I have a cell I want to give me each salespersons total is...

This is my Current line of Code on my sheet. Its purpose it to autofill a blank cell with a remaining value. My goal is to apply this same code two more times for two other independent range of cells. The Second range of cells is K4, N4, and P4, and the Third Range of cells is V4, AC4, AG4, AK4...

Hello, I'm using Excel 2010. I use dynamically named ranges to grow and shrink as the data grows and shrinks. An example is here: =OFFSET('All PO''s'!$C$9,0,0,COUNTA('All PO''s'!$C:$C)-3,COUNTA('All PO''s'!$9:$9)-2) When opening a workbook linking to another workbook with one of these...

i heard it is possible,sadly i didnt manage to achieve this function(the code either gives me an object error or goes to an infinite loop) anyone done that before and can share his knowledge? the code i tried: Sub pdf_To_Excel_early_Binding() Dim myWorksheet As Worksheet Dim wordApp As...

Hi! I have a scenario here: I used RANKX to rank 13 "Regionais" based on the Column "Crescimento": MEASURE Ranking = RANKX ( ALLEXCEPT( fCrescimento ;fCrescimento[Ano]); CALCULATE ( MAX ( fCrescimento[Crescimento] ) ); ; ; DENSE ) So far so Good. I got what I wanted...

Hello, I have a macro that will duplicate the value cells C3:C10 to the cell in column B directly next to it. So, if C4=Bacon, then it will automatically put "Bacon" into B4. Awesome... now, I need to find a way to have this be triggered by ANY checkbox on the sheet being checked. I can link the...

Hello, I can usually find the answers I need online and modifying to suit my needs, but I'm just getting started in VBA and I have not had success finding a solution for this issue and would appreciate any help. I have a range of cells in column O that I want to compare with the values in...

Hi, I am a novice to vba. I am trying to create a custom function to compare a given date with today's date and if the difference between the given date and today's date is more than 14 days then display the difference in dates in the worksheet cell and highlight it. else...

Hello, I was able to search and find to codes that independently was able to get to work/accomplish what I want it to do. However when I try to include them in the same sheet, it looks like code#2 cancels out the first one. Is there a way to combine the two so they both work? Code 1...

HI, I hope I formulated the topic correctly. What I want to do is to multiply Rooms by ADR for each date and sum them together to get total revenue for all days in a given segment (for example in row 5 and the result will be in cell S5). I thought of going with SUMPRODUCT but cannot figure out...

Hello, Formula : Dim machines As String Dim wk As Integer Dim var As Integer machines = "LB300" wk = 1027 var = Application.WorksheetFunction.CountIfs(Sheets("Hoofd-Overzicht").Range("A:A"), "&wk&", Range("D:D"), "&machine&") For x = 1 To ((Range("$F$3") - 1) /...

I have 7 columns C to I, all of the same length. I want to enter formulae in rows after the last cell in column I. The formulae include an absolurte cell regerence to the last cell in Column I. For example, if the last row of column I is row number 12, the formula in cell I13 would be R12C6 +...