defining a range an find the range address value

[rvkcools]

Hi folks

In vba

can we define a range as value for example

range(selection,selection.end(xltoright))select
based on the above i would like to identify the range like range(a1:l1) and wen i add +1 is should be range(a1:l1+1) and
move to range(a1:m1).select

Please help me

 

[kevatarvind]

try below

Range(Cells(1, 1), Cells(1, Columns.Count).End(xlToLeft)).Select

 

[rvkcools]

try below

Range(Cells(1, 1), Cells(1, Columns.Count).End(xlToLeft)).Select

Thank you arvind for your great and continuous support.
thank you. the code work fine and its selecting the range of data

for example i have data from "a" to "m"
but my active cell cell should be of this code+1column extra every time that means it should be in "n"

Please hlep me.

 

[kevatarvind]

try below

Range(ActiveCell, Cells(ActiveCell.Row, 1)).Select

 

[rvkcools]

try below

Range(ActiveCell, Cells(ActiveCell.Row, 1)).Select

Range(Cells(1, 1), Cells(1, Columns.Count).End(xlToLeft)).Select</pre>by using this code it is selecting the row "m" to "a" but i want to select my activecell as m+1 = "n"

 

[kevatarvind]

oopps now i got it what you need
try below

ActiveCell.Offset(0, 1).Select

 

[rvkcools]

oopps now i got it what you need
try below

ActiveCell.Offset(0, 1).Select

wen i enter this code "

Range(Cells(1, 1), Cells(1, Columns.Count).End(xlToLeft)).Select" - it is selecting data of first row from "a" to "m" but wen i use ur code
activecell.offset(0,1).select it is selecting "b1" but i want to select "n"

please help me


</pre>

 

[kevatarvind]

sorry but i am not getting what u need can give some sample data or more example which is ur activecell and then what u want to do