Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert two text values
I have the following code that works well:
If .Cells(x, skilly).Value = "x" And did = False Then For y = timeStart To timeStart + 7 If .Cells(x, y).Value = "." _ And counter < 6 _ And need 0 Then .Cells(x, y).Value = "ENG" counter = counter + 1 need = need - 1 End If Next y End If What I want to is insert a text value "Test" into cells 7 and 8. You can see the counter stops placing the value after 6 times I want t fill in the next 2 cells after that with a fixed string value.The resul would look like: Eng Eng Eng Eng Eng Eng Test Test Thank -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text box insert in Excel - text box lines print on second copy | Excel Discussion (Misc queries) | |||
Need a macro to insert text in a cell that already has text.Excel | Excel Discussion (Misc queries) | |||
How to Insert function right on text values e.g. 0180001640 | Excel Worksheet Functions | |||
How to Insert function right on text values e.g. 0180001640 | Excel Worksheet Functions | |||
how do I insert a function that chooses between two text values? | Excel Worksheet Functions |