Summary of Macros Excel, Cap. 6 Selección Filas y Columnas Rows - Columns @ADNDC @adanjp

This is an AI generated summary. There may be inaccuracies.
Summarize another video · Purchase Premium

00:00:00 - 00:20:00

This video is a tutorial on how to select rows and columns in Excel using macro code. The video also shows how to erase data in a table using a macro.

  • 00:00:00 In this video, tutorial expert Adam J.P. goes over how to select cells and columns in rows in Excel. He covers examples of how to create macros with no commands, and how to add a comma after a value if needed. Finally, he shows how to add an apostrophe to a value in a macro to indicate that it is a selection.
  • 00:05:00 In this video, macros are demonstrated. One example is a macro to select rows and columns. This macro is called "Ejemplo número 3." In example number 4, a range is used to select columns instead of rows. This range is "from the column number 1 to the column number 5."
  • 00:10:00 This video shows how to select columns and rows in Excel using macros. First, you'll remember what macros are on your computer. Next, you'll say what you can do or how to do it. In this example, you'll say that you will select the column up to the column. We'll close parentheses and click on play to see if it executes. The column was successfully selected. Now, you'll want to add more columns. For example, if you want to select the row headings, you'll do the following: First, you'll select the column with capital letters with a to 2.6 with a comma. Next, you'll select the row headings with a comma. Finally, you'll click on the OK button. The row headings will now be selected as columns. You can also do this for rows. Remember that these are still columns by default, but if you want to use them as ranges, you need to create variables first. Then, you can write the following: Fila activa: 5 Control ce: abc Psuv: 10 Columnas: This will create the variable Fila activa and set it to the row headings
  • 00:15:00 This video shows how to select rows and columns in Excel using macro code. First, we identify the name of the active column, and then we close the parentheses. We then set the point where the macro will select data. We play the video to see if it works, and then we select the column number 4 or the "This" column. Finally, we repeat the process for the other column. This video also shows how to erase data in a table using a macro.
  • 00:20:00 In this video, Mateos Óscar López and Jesús Manuel Briones discuss the differences between rows and columns in Excel. Óscar Lopez then goes on to say that he received a corrected task from Juan Carlos Herndez Jorge Luis Navarro, Nicolás Rojas, Hugo Arévalo, and Natalie Silva. All of them sent their tasks in the first three days of the previous tutorial, and all of them received good grades despite Óscar Lopez's strict grading system. Óscar Lopez goes on to say that he is seeing which tasks can be completed by those who have completed the previous tutorial and those who have not. Finally, he mentions that he is providing certificates to those who pass a certification exam for Microsoft Office mastery.

Copyright © 2024 Summarize, LLC. All rights reserved. · Terms of Service · Privacy Policy · As an Amazon Associate, earns from qualifying purchases.