#Excel split cells by line break code#Should the code not work for you, I suggest trying the below snippet. My scenario was a multi sheet arrangement and through some investigation I found the code was focussing on other sheets in the second nested loop - for unknown reason. I had some issues getting Kazimierz code to work until I specified exactly which sheet it should be targeting. SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=RC"īut it is not working, maybe I have adapted it incorrectly. Offset(, -1).Resize(UBound(X) - LBound(X) + 1).Value = Application.Transpose(X) Offset(1).Resize(UBound(X)).EntireRow.Insert LR = Range("AJ" & Rows.Count).End(xlUp).Row I was using the below macro, that I found on the internet: Sub Splt() UPDATE: Not sure exactly why this has been closed, assume you maybe want an example of some code. I have searched the forums for similar code, but I am having trouble adapting it for my own purpose. This is the required result: Column A Column B Column AJĮlectrical Lighting And in the same cell on a new line I need to be able to copy the entire sheet and place it all in another sheet (existing sheet), but with a new row for each new line in column AJ, as follows: Column A Column B Column AJĮlectrical Lighting This is line one of the text This text inside the cell sometimes is more than one line long and new lines have been started by pressing (ALT+Enter). One of these columns, column AJ, is a description field, and contains text describing the row item in detail. I am working on an Excel spreadsheet that has data in 39 columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |