activecell.formula

Evening gurus, I'm trying to run a formula on a adjacent cell column if the source cell contains two specific text which are defined. Formula 1 is to straight forward and will not be using InSTR function, however for Formula 2, the two specific text are "MODRETSUBUNIT" and "OPONEMS". A sample...

Hi I added the indirect function to a formula in VBA, but the macro stops at the 'activecell.formula' line below. I suspect that it's because the VBA editor doesn't like one of the inverted commas? Can anyone spot the issue here, please? The sample data this runs on is below: Sheet 1...

Hi Experts, In one of the cells i have the below formula : ActiveCell.Formula = _ "=""Hi," & Chr(10) & "" & Chr(10) & "Good Day!" & "Please confirm the PO# "" & A2" What i need is, the last A2 in the formula is not constant i want to use somethig like A & i where "i" will vary. So...

Hello everyone. I am here trying to see the transformation from a simple Macro to a Code, I know guy for you is something so Simple, but “ sorry “ no for me, I am a new self-thaught bee. I just sum two numbers with the macro recorder I got this: Range("H2").Select ActiveCell.Formula =...

Hello, I am trying to fill a cell in with a COUNTIF formula, but it appears to not be formatted correctly. I am sure I have all the necessary quotations. What is keeping this from working? It is saying that there is an unexpected error at the end of the formula with the ")"...

Hello, looking for some help to get this code working. The code I have working so far is to check if some specific text is part of a range or not. The saerch tells me if the text is French or English by searching for specific words. This part works and will place the value where the text is...

So I have the following script in my macros: activecell.Formula = "= IF(LEFT($I6,2)=""17"",""CTRL+G"","""") Instead of $I6, I need to use Offset so I can call the cell needed (and use the formula in mulitple macros). I thought I should edit swap out $I6 with ActiveCell.Offset(1,-12).Value but...

Good Afternoon guys I have a macro that takes a file from a folder, formats it, and then locks and saves it. It pulls 4 different excel CSV files from one folder. The macro worked fine until I tried to implement the last two of the four. It is giving me run time error '1004' and saying...

I am writing a spreadsheet with a macro that successfully opens a second spreadsheet and I haven’t been able to figure out/write macro code to enter a formula in cell G7 of the second spreadsheet that combines the contents of cells F7 and B7 of the second spreadsheet along with “.xlsm” which is...

How do I get my vlookup to copy down to last cell in column. Range("D2").Select ActiveCell.Formula = "=VLOOKUP(C2,'01-07 TO 01-13'!$C:$E,2,0)"

I am building an application form in excel, whereas the applicant will only be able to edit unprotected cells. I have included coding so that the number of applicants, number of facilities, and number of collateral accounts can be populated to the correct spacing in the form. For example, I...

Dear experts, I hope you can assist me. I am using a variable called "MyCell", it contains the address of the cell 3 columns left of the activecell. This address is later on being used in the vlookup formula's however the outcome produces an error. When I use the Activecell.formula statement...