Access this solution immediately by signing up as a member of excelanswers.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.
Question
VBA Excel - Offset
Dear Experts,
I have some memories about usint the Offset in VBA that
ActiveCell.Offset(1, 0) = 1
would put 1 to A2, if the active cell is A1.
Could you advise how to do that it should go to A2 but not writing anything?
thanks,
Solution
About this Solution
Sign up Now to View This Solution- Zone
- general
- Tags
- VBA Excel
- Participating Experts
- 1
- Solution Grade
- A
Log In
Stay Connected
Top Experts
-
mlmcc
10,880
0 points yesterday
Profile -
dlc110161
3,500
0 points yesterday
Profile -
jimpen
3,500
0 points yesterday
Profile -
rowanscott
2,200
0 points yesterday
Profile -
billprew
2,000
0 points yesterday
Profile -
imnorie
2,000
0 points yesterday
Profile -
kgreene
1,820
0 points yesterday
Profile -
harfang
1,800
0 points yesterday
Profile -
Netminder
1,000
0 points yesterday
Profile -
GRayL
1,000
0 points yesterday
Profile -
eeshahidt
868
0 points yesterday
Profile -
patrickab
668
0 points yesterday
Profile -
tilsant
664
0 points yesterday
Profile -
redrumkev
400
0 points yesterday
Profile -
dave4dl
400
0 points yesterday
Profile -
byundt
200
0 points yesterday
Profile -
CORBETTMJ
200
0 points yesterday
Profile -
pari123
200
0 points yesterday
Profile -
tagit
200
0 points yesterday
Profile -
broomee9
200
0 points yesterday
Profile -
Dave96
200
0 points yesterday
Profile
Posted on 2010-11-03 at 08:34:05ID: 34565403
All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.