Macro - select

  • Thread starter Thread starter puiuluipui
  • Start date Start date
P

puiuluipui

Hi, i need an macro to select all filled cells in range C10:K90.
Can this be done?
Thanks!!!
 
Range("C10:K90").SpecialCells(xlCellTypeConstants, _
xlNumbers + xlTextValues).Select

If you want to select xlErrors and xlLogical add those to xlNumbers +
xlTextValues
 
It's perfect!
Thanks!

"Jacob Skaria" a scris:
Range("C10:K90").SpecialCells(xlCellTypeConstants, _
xlNumbers + xlTextValues).Select

If you want to select xlErrors and xlLogical add those to xlNumbers +
xlTextValues
Click to expand...
 
Hi, i encountered a problem and i need the macro to select a square from the
first left cell to the last right cell and from the top cell to the bottom
cell.

Can this be done?
Thanks!

"Jacob Skaria" a scris:
 
Try the below..

Dim strAddress As String, arrAddress As Variant
strAddress = Range("C10:K90").SpecialCells(xlCellTypeConstants, _
xlNumbers + xlTextValues).Address
arrAddress = Split(Replace(strAddress, ":", ","), ",")
Range(arrAddress(0), arrAddress(UBound(arrAddress))).Select
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Corsair Vengeance K95 Mechanical Gaming Keyboard 0
Find text and move 7
IF & MAX Formula 6
Can Vba workout if a selection is part of a group? 0
Lookup 10
Macro - Using a variable number of columns in a Range 2
Macro Relative Cells 3
Excel macro help needed to copy columns from one open excel toanother open excel, and shall run on a 5

Back
Top