| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need a visual basic code....please | Excel Discussion (Misc queries) | |||
| I don't want to run visual basic editer code after saving... | Excel Discussion (Misc queries) | |||
| How do I protect Visual Basic for Application Code | New Users to Excel | |||
| Visual Basic code available for all open workbooks | Excel Worksheet Functions | |||
| Visual Basic Code Remains in "memory" | Excel Worksheet Functions | |||
Linear Mode
