Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row Number with Text
Michael
By "updated" I take that to mean the contents of a cell in Column A has changed (not to blank though). Is that right? And when that happens you want the row number and the letter D placed in the 15th column. Is that right? The following macro will do that. Note that this macro must be placed in the sheet module of your sheet. To access that module, right-click on the sheet tab, select View Code, and paste this macro into that module. "X" out of that module to return to your sheet. HTH Otto Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count 1 Then Exit Sub If IsEmpty(Target.Value) Then Exit Sub If Target.Column < 1 Then Exit Sub Cells(Target.Row, 15).Value = Target.Row & "D" End Sub "Michael" wrote in message ... Hi, I have the following file layed out as: Column1 Column2..... Column15 Admin 2D Dispatch 3D Fleet 4D What I am trying to do is when column 1 is updated, then on column 15 add the row for that cell, let's say cell A2, along with a character, in this case the letter D. How do I do that using VB? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to change scientific number to regular number or text | Excel Discussion (Misc queries) | |||
How to tell textbox to treat number as number, not text, and notshow zero | Excel Programming | |||
Convert a number formatted as text to a number in a macro | Excel Programming | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number) | Excel Worksheet Functions |