Ask a Question

How can I write an Excel macro to select a group of cells?

in Education by
I'm looking for a macro which can be run to select a consistent range of cells so that I can easily copy them to another spreadsheet. The range would be F3:BJ3. JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

1 Answer

0 votes
by
This should do the trick: Public Sub selectCells() Range("F3:BJ3").Select End Sub edit: for that matter, you can use the following to actually perform the 'copy' command for you as well: Public Sub selectCellsAndCopy() Range("F3:BJ3").Select Selection.Copy End Sub

Related questions

0 votes
Q: c. To copy a formula in Microsoft Excel, you select the cell and drag this symbol that appears on the lower-right corner of the cell write one word class 7 computer please help
    c. To copy a formula in Microsoft Excel, you select the cell and drag this symbol that appears on the lower ... 7 computer please help Select the correct answer from above options...
asked Dec 28, 2021 in Education by JackTerrance
0 votes
Q: To copy a formula in Microsoft Excel, you select the cell and drag this ___ write one word
    To copy a formula in Microsoft Excel, you select the cell and drag this ___ write one word Select the correct answer from above options...
asked Dec 27, 2021 in Education by JackTerrance
0 votes
Q: To copy a formula in Microsoft Excel, you select the cell and drag this ___ write one word
    To copy a formula in Microsoft Excel, you select the cell and drag this ___ write one word Select the correct answer from above options...
asked Dec 26, 2021 in Education by JackTerrance
0 votes
Q: Protecting cells in Excel but allow these to be modified by VBA script
    I am using Excel where certain fields are allowed for user input and other cells are to be protected. ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 18, 2022 in Education by JackTerrance
0 votes
Q: Protecting cells in Excel but allow these to be modified by VBA script
    I am using Excel where certain fields are allowed for user input and other cells are to be protected. ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 17, 2022 in Education by JackTerrance
0 votes
Q: which excel function is used to combine conrents from different cells into one cell?1. concatenate()2. consol()3. void()
    which excel function is used to combine conrents from different cells into one cell? 1. concatenate() 2. consol() 3. void() 4.main() Select the correct answer from above options...
asked Dec 14, 2021 in Education by JackTerrance
0 votes
Q: How can I make my HTML table be 100% wide AND have all of its cells only be as wide as their contents?
    I have this grid: If I change the tables width from 100% to auto, table collapses horizontally. Which ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 26, 2022 in Education by JackTerrance
0 votes
Q: how can i create a script in which i can search someone number and it will provide me name, country, email in an excel file format.(php is used in this)
    how can i create a script in which i can search someone number and it will provide me name, country, email in an ... is used in this) Select the correct answer from above options...
asked Dec 23, 2021 in Education by JackTerrance
0 votes
Q: how can i create a script in which i can search someone number and it will provide me name, country, email through truecaller database in an excel file format
    how can i create a script in which i can search someone number and it will provide me name, country, email ... an excel file format Select the correct answer from above options...
asked Dec 23, 2021 in Education by JackTerrance
0 votes
Q: From a group of 3 boys and 2 girls, we select two children. What would be the sample space for this experiment ?
    From a group of 3 boys and 2 girls, we select two children. What would be the sample space for this experiment ? Select the correct answer from above options...
asked Nov 15, 2021 in Education by JackTerrance
0 votes
Q: in split cell window we can specify the number of(i) Rows and cells(ii) Rows and Columns(iii) Columns and Cells
    in split cell window we can specify the number of (i) Rows and cells (ii) Rows and Columns (iii) Columns and ... (iv) Tables and Cells Select the correct answer from above options...
asked Dec 5, 2021 in Education by JackTerrance
0 votes
Q: in split cell window we can specify the number of(i) Rows and cells(ii) Rows and Columns(iii) Columns and Cells
    in split cell window we can specify the number of (i) Rows and cells (ii) Rows and Columns (iii) Columns and ... (iv) Tables and Cells Select the correct answer from above options...
asked Nov 26, 2021 in Education by JackTerrance
0 votes
Q: in split cell window we can specify the number of(i) Rows and cells(ii) Rows and Columns(iii) Columns and Cells
    in split cell window we can specify the number of (i) Rows and cells (ii) Rows and Columns (iii) Columns and ... (iv) Tables and Cells Select the correct answer from above options...
asked Nov 25, 2021 in Education by JackTerrance
0 votes
Q: Write the Nernst equation and `EMF` of the following cells at `298K :` `a.` `Mg(s)|Mg^(2+)(0.001M)||Cu^(2+)(0.0001M)|Cu(s)` `b.` `Fe(s)|Fe^(2+)(0.001M
    Write the Nernst equation and EMF of the following cells at 298K: a. Mg(s)|Mg2+(0.001M)||Cu2+(0.0001M)|Cu(s) b. ... )|H2(g)(1bar)|Pt(s) Select the correct answer from above options...
asked Jan 5, 2022 in Education by JackTerrance
0 votes
Q: How can I use wildcards to `cp` a group of files with the AWS CLI
    I'm having trouble using * in the AWS CLI to select a subset of files from a certain bucket. Adding * to the ... s3://data/2016-08*. Select the correct answer from above options...
asked Jan 30, 2022 in Education by JackTerrance

© Copyright 2018-2023 www.Blogmepost.com. All rights reserved. Developed by Blogmepost.

...