Selection of Used Cells through Macros

[Selva]

Hi,

How Can I select used cells or typed cells through macros.

For example:

I have entered the value 810 in cell A1 and 1230 in cell F2.

Now, I need to select from cell A1 to cell F2 through macros.

Please can you send me the solution.

regards,

Selva

 

[erik.van.geit]

Hi, Selva,

WELCOME to the Board !!!

Not sure for 100% what your needs are: so three examples.

Range("A1:F2").Select
ActiveSheet.CurrentRegion.Select
ActiveSheet.UsedRange.Select

Clicking on one of those words within your VBEditor, help will popup.

kind regards,
Erik