Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CONCATENATE code
I get a Type Mismatch error with this code.
Where I want to start at cell A8 to the last entry in col A and produce the results to col H, H8 and down. Then code to copy paste special values H8 to end of column in place. Sub ConcTestx() 'Type Mismatch error Dim LastRow As Long Dim Ws As Worksheet Set Ws = Sheets("Sheet1") LastRow = Ws.Range("A8:A" & Range("A" & Rows.Count).End(xlUp).Row) Ws.Range("H8:H" & LastRow).Formula = "=A2&B2&C2&D2&E2&F2&G2" 'paste special values in place here End Sub Thanks, Howard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ron de bruins code won't concatenate | Excel Programming | |||
Concatenate | Excel Worksheet Functions | |||
VB code to concatenate 100+ cells | Excel Programming | |||
post code & suburb concatenate | Excel Discussion (Misc queries) | |||
I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel |