Macro 2 insert formula if part of cell contains specific text
If you are looking for more than one instance have a look in the vba help index for FINDNEXT. -- Don Guillett Microsoft MVP Excel SalesAid Software "Joek" wrote in message ... I am trying to create macro that will insert a formula in a cell depending on part of the contents of another cell. E.G. If cell C2 contains the text " v " (lower case v with spaces each side) then input a formula in C4 I need a macro because I nned to check a list of entries for three different part text entries. I can do the loop and IF etc its just the 'If the cell contains....... |
All times are GMT +1. The time now is 11:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com