How Can I ask a macro to pull numerical data from a cell and ask the cursor to go to the cell number that was in the cell
2006-10-19 23:54:15 · 7 answers · asked by Anonymous in Computers & Internet ➔ Programming & Design
Assuming that you stay in the same column
if cell A1=31 then how to go to cell A31
Range("A" & Range("A1")).Select
if you want to go to B31 then
Range("B" & Range("A1")).Select
2006-10-20 00:36:33 · answer #1 · answered by Anonymous · 0⤊ 1⤋
you need to set that cell as the macro i think then all the data you want to go to that cell
2006-10-20 07:04:31 · answer #2 · answered by Ro' Doggs 3 · 0⤊ 1⤋
Ask first then if the macro and the cursor don't respond you can turn to help menu
2006-10-20 07:04:12 · answer #3 · answered by justpristine 2 · 0⤊ 1⤋
Vijay kumar try this link
http://www.google.co.uk/search?hl=en&q=in+excel+macro+to+pull+numerical+data+from+a+cell&btnG=Search&meta=
2006-10-20 06:57:14 · answer #4 · answered by Joe_Young 6 · 0⤊ 0⤋
eg
Range("A1:B2").value
is how u get the numerical data
eg
Range("C3").Select
is how you select a cell
2006-10-20 15:03:09 · answer #5 · answered by oxygengiver2000 2 · 0⤊ 0⤋
What? I think your question is harder than the answer.
2006-10-20 06:57:52 · answer #6 · answered by c00kies 5 · 0⤊ 1⤋
ask more people
2006-10-20 07:02:41 · answer #7 · answered by Anonymous · 0⤊ 1⤋