| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenate a row that is selected and include blank cells
Can this neat little snippet be altered to work on a row of selected cells AND include the blanks?
Works fine as is with =ConcatMe("A1:Z1") but omits any blanks. I may want only A1:G1 including the blank cells if any. =ConcatMe('Selection') Thanks, Howard Option Explicit Function ConcatMe(Rng As Range) As String Dim cl As Range ConcatMe = "" For Each cl In Rng ConcatMe = ConcatMe & cl.Text Next cl End Function |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filters will not include cells beyond the first blank? | Excel Discussion (Misc queries) | |||
| OFFSET to include blank cells | Excel Worksheet Functions | |||
| Macro to concatenate previously selected cells | Excel Programming | |||
| blank cells that include text | Excel Worksheet Functions | |||
| Moving between a cell that is selected to include a range of cells in that row | Excel Programming | |||
Threaded Mode
