Align vertical data horizontally while copying previous columns along

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Align vertical data horizontally while copying previous columns along

01-28-2019, 05:48 AM

alpha

Windows 10 Align vertical data horizontally while copying previous columns along

Office 2010 64bit

Novice

Join Date: Jun 2018

Posts: 18

In the macro, replace

Code:

lk = .Cells(r, .Columns.Count).End(xlToLeft).Column

by:

Code:

lk = 16

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vertical Text Alignment with Adjacent Columns	kdutrisac	Word Tables	2	06-26-2017 12:38 PM
Copying specific columns of a table to WORD and deleting rows	ffinley	Word VBA	5	12-07-2015 04:01 PM
Copying and pasting values with unequal data columns	grexcelman	Excel Programming	5	12-05-2014 11:36 AM
Vertical align to bottom of cell when row wraps to next page	lausianne	Word Tables	3	02-28-2014 05:20 PM
Copying data from sheet with deleted columns creates blanks	ZGreyArea	Excel	1	11-20-2013 10:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:18 AM.