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 |