excelmacro10's profile picture.

excelmacro

@excelmacro10

Bạn có thể thích

Activecell row number, row_no= ActiveCell.Row


column no of activecell. column_no = Split(ActiveCell.Address, "$")(1)


Move 1 cell right, ActiveCell.Offset(0, 1).Range("a1").Select. Move 1 cell down, 2 cell left, ActiveCell.Offset(1,-2).Range("a1").Select.


Use LISTBOX in excel sheets; Data > Validation Validation criteria > List Source > =$a$1:$a$5 click ok. (input a1 to a5 your datas.)


Tài khoản này hiện không theo dõi ai

United States Xu hướng

Bạn có thể thích

Loading...

Something went wrong.


Something went wrong.