Thread: Help to spead up macro - Find and Replace in Tables, Cut Paste Next Cells
View Single Post
 
Old 08-19-2019, 08:39 AM
Cendrinne's Avatar
Cendrinne Cendrinne is offline Windows 10 Office 2013
Competent Performer
  
Join Date: Aug 2019
Location: Montreal Quebec Canada
Posts: 190
Cendrinne is on a distinguished road
Default
Hello Guessed,


I got an error message at this line, ''aRng.Cells(1).Next.Range.FormattedText= aRng.FormattedText''
stating (well I have to translate it from French to English, so please I apologize in advance, if I don't write the correct terms).... Execution Error '91': Variable object or Variable bloc With, not defined


I hope this helped.
















Reply With Quote