Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert dummy variables
Hi, here is my problem. I will have data in different cells each time such
as A1:C10, A1:H100, for example. What i need is macro that will insert a dash (-) under the last line of value in each cell. For example if there are values in cells A1:C10 I need a dash in each of the cells A11:C11. Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert dummy variables
This will work for any table, even in the middle of a worksheet:
Sub underline() Dim r, rr, rrr As Range Set r = Selection nLastRow = r.Rows.Count + r.Row nFirstColumn = r.Column nLastColumn = r.Columns.Count + r.Column - 1 Set rr = Range(Cells(nLastRow, nFirstColumn), Cells(nLastRow, nLastColumn)) For Each rrr In rr rrr.Value = "_" Next End Sub Just select the table and run the macro. -- Gary's Student "Chris_t_2k5" wrote: Hi, here is my problem. I will have data in different cells each time such as A1:C10, A1:H100, for example. What i need is macro that will insert a dash (-) under the last line of value in each cell. For example if there are values in cells A1:C10 I need a dash in each of the cells A11:C11. Thanks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert dummy variables
Sub abc()
Dim rng as Range, rw as Range Dim cell as Range Set rng = Range("A1").CurrentRegion Set rw = rng.Offset(rng.Rows.Count, 0).Resize(1) For Each cell In rw cell.Value = "-" Next End Sub -- Regards, Tom Ogilvy "Chris_t_2k5" wrote in message ... Hi, here is my problem. I will have data in different cells each time such as A1:C10, A1:H100, for example. What i need is macro that will insert a dash (-) under the last line of value in each cell. For example if there are values in cells A1:C10 I need a dash in each of the cells A11:C11. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dummy Variables | Excel Discussion (Misc queries) | |||
Creating dummy variables in Excel | Excel Worksheet Functions | |||
Creating dummy variables in Excel | Excel Worksheet Functions | |||
vb dummy - two routines | Excel Programming | |||
Question for dummy | Excel Programming |