Setting ActiveCell address to an Absolute Reference

[PedroVision]

The image shows the error message received when I tried to set the ActiveCell to an absolute value...the pop up suggest there is a way to set the address to an absolute cell...at this point in time, I can't see my way out of the weeds.

The following works to set the ActiveCell to a relative cell from the current ActiveCell...and...it works VERY nicely...

ActiveCell (3).Select...this works quite nicely as well...ActiveCell(3, 2).Select

My question...how can the ActiveCell be set to...(Row3,Column 2)???

Does anyone know if there is a definitive guide to the ActiveCell function???

 

[Peter_SSs]

.how can the ActiveCell be set to...(Row3,Column 2)???

Sub Test()
  Cells(3, 2).Activate
End Sub

It should be noted though that it is extremely rare that you need to Select or Activate a particular cell or range to work with it. Also, selecting/activating can sometimes slow your vba code considerably.
What are you intending to do once that cell is activated?

guide to the ActiveCell function???

ActiveCell is not a function

 

[kvsrinivasamurthy]

Try.
Cells(3, 2).Activate

 

[PedroVision]

Try.
Cells(3, 2).Activate

Ahhhhhhhh...success is sweet...

Many thanks!!

I've developed a program to track a 2,000 line database...every once in a while I need to select a cell on the "mother" worksheet...Cells(3, 2).Activate will be quite useful...

In essence, I've written 3 columns of this main worksheet to a listbox, and developed methods to rapidly sort, and otherwise sift through the data...enabling the addition of new lines of data, using existing data with tweaks necessary to describe the new entry...

Code writing is a true blessing...and deeply satisfying. At any rate...THANK YOU for your expert help!

"I'll be back..."

 

[PedroVision]

Sub Test()
  Cells(3, 2).Activate
End Sub

It should be noted though that it is extremely rare that you need to Select or Activate a particular cell or range to work with it. Also, selecting/activating can sometimes slow your vba code considerably.
What are you intending to do once that cell is activated?


ActiveCell is not a function

I'll insert lines of data into my spreadsheet from a listbox...based on user specification, I'll insert the info, above or below the ActiveCell...sometimes I need to specify the NEW ActiveCell based on info gleaned from the listbox collated data...developing the VBA-based multi-page custom solution has been a wonderful experience...I love program development and application.

 

[Peter_SSs]

Just the same, if you are moving the active cell with the code and then doing something in relation to that active cell (below/above/right etc) there is no need to actually move the active cell, the code can be written differently (& would be more efficient without the active cell movement). If you are interested in learning about coding more efficiently in this way then post a small section of your code where you are moving the active cell and then doing something in relation to that and we can take a look and make suggestions.

 

[PedroVision]

I've also changed the highlight color to a light cyan...I want to see the ActiveCell, in order to visually verify where the new data is about to be placed. Anything I can do to increase my confidence is desirable.

My emphasis is to make my VBA program the main focus, with my worksheet acting as a reference and repository for the data...

That being said, I am more than certain my colleagues at MrEcel could very well snap my coding up a bit! (while I am a bit rusty after a 15 year hiatus (for one reason or another), my coding didn't completely evaporate into the ether...thank God). Examples to follow at a later date...