how to copy different text from word into excel on consecutive rows

		Microsoft Office Forums > Microsoft Word > Word VBA
how to copy different text from word into excel on consecutive rows

05-08-2017, 10:06 AM

gmayor

Windows 10 how to copy different text from word into excel on consecutive rows

Office 2016

Expert

Join Date: Aug 2014

Posts: 4,142

Add

Code:

xlSheet.Cells(xlsNextRow, 2).Font.Bold = True

immediately before 'Else' i.e.

Code:

    xlSheet.Cells(xlsNextRow, 2) = Selection.Text
        xlSheet.Cells(xlsNextRow, 2).Font.Bold = True
    Else

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel VBA macro to copy specific rows and delete it	pourmalla	Excel Programming	2	04-02-2017 12:09 AM
Counting Consecutive Periods In Rows Using Numbers	Yaaseen23	Excel	18	03-24-2017 11:15 AM
Copy Underline text from Word and Paste into excel	rfaris	Excel Programming	7	10-05-2015 05:56 AM
Is it possible to copy non-contiguous rows of a Table and paste them as a separate Table in Word?	Joey Cheung	Word Tables	1	08-12-2014 05:15 PM
Find Results in excel copy the rows to another sheet	khalidfazeli	Excel	2	02-06-2013 09:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:08 AM.