The VBA macros.
5 USDThe list contains a table with N number of columns and lines. The first line of the table is the headlines.
A macro is required, which by pressing will perform the following actions:
1 . It will set the width of all columns in the table in size - 16.
2nd It will set the height of the line by a headline size - 50.
Three It formats the text of the headline as follows: Middle Align Center Wrap Text Bold 4. It will set the style of the table - "Light None";
and 5. In the headline will replace several text breaks in the emptiness:
.Replace(”Column1.mytext_1”, “”)
.Replace(”Column1.mytext_2”, “”)
.Replace(”Column1.mytext_3”, “”)
.Replace(”Column1.mytext_4”, “”)
Screenshots for MS Excel 2019
Please write your proposal.
Приветствую!
На листе есть таблица с N количеством столбцов и строк. Первая строка таблицы - заголовки.
Необходим макрос, который по нажатии будет выполнять следующие действия:
1. Установит ширину всех столбцов в таблице размером - 16.
2. Установит высоту строки заголовком размером - 50.
3. Отформатирует текст строки заголовков следующим образом:
- Middle Align
- Center
- Wrap Text
- Bold
4. Установит стиль таблицы - "Light None";
5. В строке заголовков заменит несколько текстовых отрывков на пустоту:
.Replace("Column1.mytext_1", "")
.Replace("Column1.mytext_2", "")
.Replace("Column1.mytext_3", "")
.Replace("Column1.mytext_4", "")
Скрипт под версию MS Excel 2019
Пожалуйста, напишите ваше предложение.
Client's feedback on cooperation with Valery Makarov
The VBA macros.Simple macros, all the norms.
Freelancer's feedback on cooperation with Vitali Rijenco
The VBA macros.A technically qualified customer is
-
758 38 2 I’ll make it in the morning (or I’ll send it out in a few hours if it’s not late for you).
The minimum acceptable price for the freelancer. Supplement of 50%.
Great experience in macros - see. My profile.
Сделаю на утро (или вышлю через пару часов, если для Вас это будет не поздно).
Указал минимально допустимую цену для фриланс-биржи. Предоплата 50%.
Огромный опыт в макросах - см. мой профиль.
Current freelance projects in the category Microsoft .NET
Modification of the application - reverse engineeringThere is an application that contains vbscript used to control the application (buttons). What I want is to hide the code written in Vbscript syntax. By hiding, I mean that it should not be visible to anyone, and it should work the same way. So, can you suggest a better way to… Microsoft .NET, Web programming |
Software application “College Graduate Guide” (C# Windows Form)Create the GUI program "Visual Studio C#, Windows Forms" which provides: List of graduates; Adding and updating information; use of different filters and criteria to find specific graduates according to the professional direction, the place of work, the year of release; The… C#, Microsoft .NET ∙ 18 proposals |
by SarafanIn search of a backend developer who will take our project for improvement. We have tg bots and mobile apps. Accordingly, there are groups of users with different levels of access and personal offices. Catalogue of goods and authorization through telegram. Payments are made on… C#, Microsoft .NET ∙ 6 proposals |
Senior .net Developer with Desktop Applications Development ExperienceSenior .net developer with experience in developing desktop applications for interaction with external equipment Microsoft .NET, Software protection and security ∙ 2 proposals |
Create a single data storage for reports, a single entry pointRequirements for the programming: 1 .The programming language is C#, .NET.2ndDesktop application on the WPF framework: Omron PLC survey, data storage in SQLite BD, sending through HTTP to the server, generating Excel reports, sending by smtp, sending notifications in… C#, Microsoft .NET ∙ 4 proposals |