Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I join two formulas?
Hi,
There are many different formulas in one of my columns (C). I want to add "+F" to all of the formulas. For example: ... "+F12" to be placed at the end of the formula of C12 "+F13" to be placed at the end of the formula of C13 ... Any suggestion how to do it? (I hope my question is clear.) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I join two formulas?
On Sun, 10 Aug 2008 03:00:00 -0700, Little Researcher
wrote: Hi, There are many different formulas in one of my columns (C). I want to add "+F" to all of the formulas. For example: ... "+F12" to be placed at the end of the formula of C12 "+F13" to be placed at the end of the formula of C13 ... Any suggestion how to do it? (I hope my question is clear.) Try this macro to change the first 1000 rows in column C Sub change_formula() Dim c As Range For Each c In Range("C1:C1000") If c.HasFormula Then c.Formula = c.Formula & "+F" & c.Row End If Next c End Sub If you are not familiar on how to create a macro you can find some instructionunder "Create a macro using Microsoft Visual Basic" here http://office.microsoft.com/en-us/ex...047111033.aspx Hope this helps / Lars-Åke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Join tables like inner join in Access | Excel Discussion (Misc queries) | |||
Text join formulas working but act as straight text when modified | New Users to Excel | |||
Join text | Excel Discussion (Misc queries) | |||
join two spreadsheets | Excel Discussion (Misc queries) | |||
join 2 spreadsheets | Excel Discussion (Misc queries) |