Selecting Cells With Visual Basic or Macro Code

[Guest]

Hello,

Imagine random numbers in cells between a1 and d5.

In cell a7 you could type a number , like 3
And in cell a8 you could type a number, like 4

What is the macro (or VB) code to return a value in b8 which is the random
number found in row 3, column 4, i.e. d3?

I know the excel formula, but not the VB.

Many thanks

 

[JE McGimpsey]

One way:

MsgBox ActiveSheet.Cells(3, 4).Value

 

[Guest]

Thats well good !!

I changed it to a user defined function

Thanks

I'm really happy now !

 

[Guest]

.... On second thought

Although its great, i'm half way there ...

How do I get the value to display in another cell on the sheet ?

If that statement is confusing, its clearer in my original question ..!

Many thanks

 

[JE McGimpsey]

Perhaps:

With ActiveSheet
.Cells(5, 10).Value = .Cells(3, 4).Value
End With

 

[Guest]

That sounds really cool

I'm gonna try it over the weekend - its 6pm on Friday now - I'm leaving the
office

But it looks good, so i'm sure i can play around with it !!!

ThaNKs !!