-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
cell.formula
-
P
Multiplying Textbox Value
I have the below code that works: Private Sub CommandButton1_Click() Dim cell As Range For Each cell In Range("I2:I2") cell.Formula = Replace(cell.Formula, "100,", TextBox1.Value + ",") cell.Formula = Replace(cell.Formula, "260000000000,", TextBox2.Value + ",") Next cell End Sub But, I would...- pmgibs
- Thread
- Replies: 3
- Forum: Excel Questions
-
J
Looking for quoicker method with "cell.Formula = Replace(cell.Formula"
Hi there, is there an quicker method to perform the following on 'ActiveSheet"? Thank You For Each cell In ActiveSheet.Range("h2:h" & lr) cell.Formula = Replace(cell.Formula, "ACA", "ACA/52") cell.Formula = Replace(cell.Formula, "ACB", "ACB/18") cell.Formula = Replace(cell.Formula, "ACG"...- jamada
- Thread
- Replies: 6
- Forum: Excel Questions
-
F
Copy Subtotals
Below is a very basic extract from a large worksheet: _________________A_____B__________________C_____D 1_EXPENSE______________JAN________________FEB___MAR 2_Salaries_______________100________________130__125 3_Benefits_______________120________________150__145 4_SALARIES &...- fddekker
- Thread
- Replies: 2
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Filter multiple worksheets based on list
- Started by alkaline55
- Replies: 36
Hi everyone, I'm new to VBA and looking for some guidance. I'd like to filter Column A on three different tabs based on the first value of a list... -
Calling a Macro pretty simple yet...
- Started by erutherford
- Replies: 31
I have a form that enters data in Col A, B, C. A macro runs next that groups the data into Col D Here is the macro ( runs fine manually) [code]... -
VBA & Conditional Format
- Started by Patriot2879
- Replies: 30
Hi good afternoon, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and... -
Complex Heat Map using conditional formatting
- Started by Corried
- Replies: 30
Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL... -
Filtering data VBA with 3 criteria
- Started by cortexnotion
- Replies: 29
Good Morning, I stumbled across this forum through some research and I was hoping you could help me with some VBA code. I have a data set... -
VBA copy data from multiple worksheets and paste in a specific, preformatted sheet.
- Started by Pettel
- Replies: 29
Hi everyone, I'm trying to gather information from multiple worksheets into a single preformatted table. I've started with a dialog folder picker...