Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
range to cell
Hello,
I am writing a program. I have a excel range object. And I want to point another cell at this range. how can I do that? On the range there is column = 4 row = 3. but I cannot just say =4,3 or something like that? don't you need =D3? why is the column D and not 4? strange |
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
range to cell
=sheets("Sheet1").range("D4")
or =sheets("Sheet1").cells(3, 4) -- HTH... Jim Thomlinson "greg" wrote: Hello, I am writing a program. I have a excel range object. And I want to point another cell at this range. how can I do that? On the range there is column = 4 row = 3. but I cannot just say =4,3 or something like that? don't you need =D3? why is the column D and not 4? strange |
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
range to cell
Sorry should be D3 not D4...
-- HTH... Jim Thomlinson "Jim Thomlinson" wrote: =sheets("Sheet1").range("D4") or =sheets("Sheet1").cells(3, 4) -- HTH... Jim Thomlinson "greg" wrote: Hello, I am writing a program. I have a excel range object. And I want to point another cell at this range. how can I do that? On the range there is column = 4 row = 3. but I cannot just say =4,3 or something like that? don't you need =D3? why is the column D and not 4? strange |
#4
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
range to cell
thanks jim.
however i am still a bit confused. lets say i want to not assign the value. but reference the cell. so if i am in cell A1 or 11 if I do this Excel.ActiveCell = Excel.ActiveSheet.Cells(1, 2) it will just asign the value of the cell and this Excel.ActiveCell = "=" & Excel.ActiveSheet.Cells(1, 2) will be "=<value of cell" is there a way to just reference the cell? thanks "Jim Thomlinson" wrote in message ... Sorry should be D3 not D4... -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: =sheets("Sheet1").range("D4") or =sheets("Sheet1").cells(3, 4) -- HTH... Jim Thomlinson "greg" wrote: Hello, I am writing a program. I have a excel range object. And I want to point another cell at this range. how can I do that? On the range there is column = 4 row = 3. but I cannot just say =4,3 or something like that? don't you need =D3? why is the column D and not 4? strange |
#5
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
range to cell
So if I follow you (which I am not too sure that I do) you want one cell to
reference the other cell such that when you change the cell the referenced cell is also changed??? If so you probably want to use the change event to catch changes to the first cell and then replicate those changes to the other cell. -- HTH... Jim Thomlinson "greg" wrote: thanks jim. however i am still a bit confused. lets say i want to not assign the value. but reference the cell. so if i am in cell A1 or 11 if I do this Excel.ActiveCell = Excel.ActiveSheet.Cells(1, 2) it will just asign the value of the cell and this Excel.ActiveCell = "=" & Excel.ActiveSheet.Cells(1, 2) will be "=<value of cell" is there a way to just reference the cell? thanks "Jim Thomlinson" wrote in message ... Sorry should be D3 not D4... -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: =sheets("Sheet1").range("D4") or =sheets("Sheet1").cells(3, 4) -- HTH... Jim Thomlinson "greg" wrote: Hello, I am writing a program. I have a excel range object. And I want to point another cell at this range. how can I do that? On the range there is column = 4 row = 3. but I cannot just say =4,3 or something like that? don't you need =D3? why is the column D and not 4? strange |
#6
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
range to cell
thanks for the help.
Not exactly. For example, I would Like to have cell A1 = B1 But I only have a excel range object. So in the range object I have column 2, row 1 so in my current cell, how can i reference this? instead of saying =B1? because i have column 2? is there an easy way around this? thanks for any help "Jim Thomlinson" wrote in message ... So if I follow you (which I am not too sure that I do) you want one cell to reference the other cell such that when you change the cell the referenced cell is also changed??? If so you probably want to use the change event to catch changes to the first cell and then replicate those changes to the other cell. -- HTH... Jim Thomlinson "greg" wrote: thanks jim. however i am still a bit confused. lets say i want to not assign the value. but reference the cell. so if i am in cell A1 or 11 if I do this Excel.ActiveCell = Excel.ActiveSheet.Cells(1, 2) it will just asign the value of the cell and this Excel.ActiveCell = "=" & Excel.ActiveSheet.Cells(1, 2) will be "=<value of cell" is there a way to just reference the cell? thanks "Jim Thomlinson" wrote in message ... Sorry should be D3 not D4... -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: =sheets("Sheet1").range("D4") or =sheets("Sheet1").cells(3, 4) -- HTH... Jim Thomlinson "greg" wrote: Hello, I am writing a program. I have a excel range object. And I want to point another cell at this range. how can I do that? On the range there is column = 4 row = 3. but I cannot just say =4,3 or something like that? don't you need =D3? why is the column D and not 4? strange |
#7
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
range to cell
Greg
Sub getnextCol() For Each c In Selection c.Value = c.Offset(0, 1) Next End Sub select the column and run - it copies the the values in the next column so as you say, A1 = B1 Hope this helps Peter "greg" wrote: thanks for the help. Not exactly. For example, I would Like to have cell A1 = B1 But I only have a excel range object. So in the range object I have column 2, row 1 so in my current cell, how can i reference this? instead of saying =B1? because i have column 2? is there an easy way around this? thanks for any help "Jim Thomlinson" wrote in message ... So if I follow you (which I am not too sure that I do) you want one cell to reference the other cell such that when you change the cell the referenced cell is also changed??? If so you probably want to use the change event to catch changes to the first cell and then replicate those changes to the other cell. -- HTH... Jim Thomlinson "greg" wrote: thanks jim. however i am still a bit confused. lets say i want to not assign the value. but reference the cell. so if i am in cell A1 or 11 if I do this Excel.ActiveCell = Excel.ActiveSheet.Cells(1, 2) it will just asign the value of the cell and this Excel.ActiveCell = "=" & Excel.ActiveSheet.Cells(1, 2) will be "=<value of cell" is there a way to just reference the cell? thanks "Jim Thomlinson" wrote in message ... Sorry should be D3 not D4... -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: =sheets("Sheet1").range("D4") or =sheets("Sheet1").cells(3, 4) -- HTH... Jim Thomlinson "greg" wrote: Hello, I am writing a program. I have a excel range object. And I want to point another cell at this range. how can I do that? On the range there is column = 4 row = 3. but I cannot just say =4,3 or something like that? don't you need =D3? why is the column D and not 4? strange |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RANGE EXCEL copy cell that meets criteria in a range | Excel Worksheet Functions | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
Change cell colour for a cell or range within a predefined range | Excel Programming | |||
Range.Find returns cell outside of range when range set to single cell | Excel Programming |