answersLogoWhite

0

Sub Clear_Columns()

'

' Select columns from which to clear contents of all cells in the columns

Range("A:A,E:E,F:F,J:J,N:N,Z:Z").Select

' Clear contents of all columns in selected range

Selection.ClearContents

' Return cursor to cell A1 (optional)

Range("A1").Select

End Sub

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is a macro evolution?

Micro-evolution is not only a part of macro-evolution, it is the same mechanism as macro-evolution. Macro-evolution includes speciation, as a result of continuing micro-evolution.


What is a matrix with the same number of rows as columns?

A matrix having the same number of rows and columns is a SQUARE MATRIX.


Are rows and columns the same?

No. Both have cells, but rows are horizontal and columns are vertical.


When sorting a column do the cells in a row move together?

Sorting only affects the selected area in a spreadsheet. The cells in the rows of columns selected will move. Cells on the same row but not in the columns that have been selected will not move.Sorting only affects the selected area in a spreadsheet. The cells in the rows of columns selected will move. Cells on the same row but not in the columns that have been selected will not move.Sorting only affects the selected area in a spreadsheet. The cells in the rows of columns selected will move. Cells on the same row but not in the columns that have been selected will not move.Sorting only affects the selected area in a spreadsheet. The cells in the rows of columns selected will move. Cells on the same row but not in the columns that have been selected will not move.Sorting only affects the selected area in a spreadsheet. The cells in the rows of columns selected will move. Cells on the same row but not in the columns that have been selected will not move.Sorting only affects the selected area in a spreadsheet. The cells in the rows of columns selected will move. Cells on the same row but not in the columns that have been selected will not move.Sorting only affects the selected area in a spreadsheet. The cells in the rows of columns selected will move. Cells on the same row but not in the columns that have been selected will not move.Sorting only affects the selected area in a spreadsheet. The cells in the rows of columns selected will move. Cells on the same row but not in the columns that have been selected will not move.Sorting only affects the selected area in a spreadsheet. The cells in the rows of columns selected will move. Cells on the same row but not in the columns that have been selected will not move.Sorting only affects the selected area in a spreadsheet. The cells in the rows of columns selected will move. Cells on the same row but not in the columns that have been selected will not move.Sorting only affects the selected area in a spreadsheet. The cells in the rows of columns selected will move. Cells on the same row but not in the columns that have been selected will not move.


What are the scopes of macro economics?

same as of micro economics


What does it mean to balance the columns on page in word 2007?

To Make all the columns the same length.


What do the columns of periodic table have in common?

Atomic Weightsthey have same number of valence electrons and hence similar chemical properties.


All columns in a table must be of the same width?

Columns in an Excel table can be any width you like.


Copying and cutting are the same functions in Microsoft Word?

no both are not same if we do copy it s not delete to that place but we use cut iwill be delete no both are not same if we do copy it s not delete to that place but we use cut iwill be delete


How do you delete the floor on sims life stories?

you delete it the same way you delete walls ~anonymus


How do you delete flooring on sims life stories?

you delete it the same way you delete walls ~anonymus


How do you ensure a reference never changes when you insert rows or copy or move formulas in a worksheet?

Use absolute referencing, but following the column letter or row number with the dollar sign. EXAMPLE: The relative cell address D23 can change relative to other cells when you insert or delete rows or columns. The absolue cell address D$23$ always remains the same.