Moving around worksheet using macro

[dhoom98]

Hi,
I am looking for macro which can be used to move around the cells. For example if I want to enter data form C5:F10 which means I want to edit 6 rows down first than cursor move to Colum D5 and enter value in cell D5 to D10 than again move to E5 Colum to E10 and so on. I do not want to change direction for curser from option menu for down or left.

Macro can be take instruction from fixed cell how many columns and raw to be used for entry with sequence (down or left). Curser can be move left 5 cells then move to down or move down 5 rows than move to left

 

[JackDanIce]

Welcome to the board.

You don't specify what values you want to put into the cells. This macro takes the number of rows from cell A1 and then the number of columns from cell B1 and starts from cell C5:

Sub MoveMe()

Dim x as Long, y as Long

Application.ScreenUpdating = False

For x = 5 to Range("A1")
   For y = 3 to Range("B1")
      Cells(x, y) = x * y
   Next y
Next x

Application.ScreenUpdating = True

End Sub

 

[dhoom98]

Measurement values I am going to enter to calculate Avg. and Std.
Data entry can be start from C5 or C15 or any row in colum C. Can I change starting cell?

 

[JackDanIce]

The number 5 in red below refers to starting row 5, the number 3 refers to column 3

Sub MoveMe()

Dim x as Long, y as Long

Application.ScreenUpdating = False

For x = 5 to Range("A1")
   For y = 3 to Range("B1")
      Cells(x, y) = x * y
   Next y
Next x

Application.ScreenUpdating = True

End Sub

 

[dhoom98]

Thanks it works the way I want.

 

[JackDanIce]

You're welcome