Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Heck, yeah; it's practically the one fundamental necessity! If we couldn't
do even that, there wouldn't be much point in writing Excel programs at all. TomPl was right as far as he went: ActiveCell.Value will get you the contents of the cell that is currently selected. I just wanted to go a bit further: Your program doesn't have to be limited to the active cell, but can also get the contents of "A4", of the cell in row 23 column 5, of the cell at row x1+3, column x2*2, of the top left cell in the selected range, of the next cell that contains the string "000", pretty much anything you can think of. It can get the text value, the formula, the font size, the column width, its protection status...again, pretty much anything you can do in Excel you can control from VBA/Excel. Pardon my enthusiasm; you're just asking too small, that's all. :-) --- "RMS" wrote: Is it possible to pass the contents of an Excel worksheet Cell to a VBA variable for further processing? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Passing variable among controls | Excel Programming | |||
VBA - Passing Cell Location To Variable | Excel Programming | |||
Passing variable to Access | Excel Programming | |||
Passing variable to VarType of other Variable | Excel Programming | |||
Passing variable from one sub to another | Excel Programming |