excelmacro10's profile picture.

excelmacro

@excelmacro10

내가 좋아할 만한 콘텐츠

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.)


이 계정은 현재 아무도 팔로우하지 않습니다

United States 트렌드

내가 좋아할 만한 콘텐츠

Loading...

Something went wrong.


Something went wrong.