Problems combining selected cells

p45cal · #1 08-11-2022, 09:07 AM

Try this for the macro:

Code:

Sub CopySelectedCells()
For Each cll In Selection.Cells
  Range("C15").Value = Range("C15").Value & " " & cll.Value
Next cll
End Sub

It will only copy text, no formatting such as bold colour etc.
Note also that it will copy the cells in the order you selected them in, even if the cells are next to each other. For example you could hold the Ctrl key down then in sequence click on C10, then C9 then C8, you'll get:
Only formulas and number formatting. The width of one column or range of columns to another column or range of columns. Cell contents and formatting except cell borders.

It's not quite perfect, it adds a space for the first cell copied too.

14spar15 · #2 08-11-2022, 11:21 AM

I like it....That solves the major flaw in this application and will make it much more usefull. Thanks. Is it unlikely that there is a solution to clear the content of cell C15 on entering any sheet in this workbook. I found a way to do this for individual sheets but it would require changes on each sheet and each new sheet in the future.

p45cal · #3 08-12-2022, 04:10 AM

Quote:

Originally Posted by 14spar15

Is it unlikely that there is a solution to clear the content of cell C15 on entering any sheet in this workbook. I found a way to do this for individual sheets but it would require changes on each sheet and each new sheet in the future.

How did you do it?
Check out the ThisWorkbook code-module and its Workbook_SheetActivate(ByVal Sh As Object), you could exclude certain sheets.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
combining cells with multiple choices	H28Sailor	Excel	1	01-13-2017 11:02 PM
Combining several cells data into one single cell	H28Sailor	Excel	6	01-09-2017 06:00 AM
Combining 2 tables into 1 and use Table2's column widths (hoping for workaround dealing merged cells	CodingGuruInTraining	Word VBA	24	10-07-2015 07:48 PM
Combining daily S.M.A.R.T data in a meaningfull sheet (2 problems)	Vitolio	Excel	1	07-10-2013 08:58 AM
Combining Text from Table Cells	robmorleyuk	Word	1	11-01-2011 07:24 AM