Selecting Cells With Visual Basic or Macro Code
 

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

Selecting Cells With Visual Basic or Macro Code
 

One way:

MsgBox ActiveSheet.Cells(3, 4).Value

In article ,
RajenRajput1 wrote:

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

Selecting Cells With Visual Basic or Macro Code
 

Thats well good !!

I changed it to a user defined function

Thanks

I'm really happy now !

"JE McGimpsey" wrote:

One way:

MsgBox ActiveSheet.Cells(3, 4).Value

In article ,
RajenRajput1 wrote:

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

Selecting Cells With Visual Basic or Macro Code
 

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



"RajenRajput1" wrote:

Thats well good !!

I changed it to a user defined function

Thanks

I'm really happy now !

"JE McGimpsey" wrote:

One way:

MsgBox ActiveSheet.Cells(3, 4).Value

In article ,
RajenRajput1 wrote:

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

Selecting Cells With Visual Basic or Macro Code
 

Perhaps:

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


In article ,
RajenRajput1 wrote:

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



"RajenRajput1" wrote:

Thats well good !!

I changed it to a user defined function

Thanks

I'm really happy now !

"JE McGimpsey" wrote:

One way:

MsgBox ActiveSheet.Cells(3, 4).Value

In article ,
RajenRajput1 wrote:

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

Selecting Cells With Visual Basic or Macro Code
 

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 !!

"JE McGimpsey" wrote:

Perhaps:

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


In article ,
RajenRajput1 wrote:

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



"RajenRajput1" wrote:

Thats well good !!

I changed it to a user defined function

Thanks

I'm really happy now !

"JE McGimpsey" wrote:

One way:

MsgBox ActiveSheet.Cells(3, 4).Value

In article ,
RajenRajput1 wrote:

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