Below macro applies a custom paragraph style to the first row of a selected table. The macro is running fine.
I also tried to apply a custom paragraph style to the first column of a selected table using VBA, but to no avail. How do I have to re-write below code so that the first column of the selected table gets the custom paragraph style?
Help is appreciated. Thank you very much in advance. Regards, Andreas
'apply a custom paragraph style to the first row of selected table
Selection.Style = "Dipl_Tbl_Kopf"
so you want the table to be worked on the first one (or all) that are selected?
then, indeed the selection object IS needed, like this:
Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.