Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Folks!
I found this code by Gord Dibben: Private Sub Worksheet_Change(ByVal Target As Excel.Range) On Error GoTo stoppit If Target.Address = "$A$2" And Target.Value < "" Then ActiveSheet.Cells(Rows.Count, 2).End(xlUp) _ .Offset(1, 0).Value = Target.Value End If stoppit: End Sub It's event code that "copies" the value entered in A2 to another column (B2:Bn). Can this code be modified so that if column B (or whatever column) is full: =COUNTA(B:B)=65536, then it starts putting the values in the next column to the right and continues in this fashion? Thanks! Biff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
matching full name to 'two column' name using sumproduct | Excel Worksheet Functions | |||
add data in column related to cell in another column - see full de | Excel Worksheet Functions | |||
Full Text is not appearing in column | Excel Discussion (Misc queries) | |||
How I can print full text bigger than column, in repeat column | Excel Discussion (Misc queries) | |||
How to specify almost full-column arguments like A3:A | Excel Discussion (Misc queries) |