Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

MS Excel Current Cell Reference

Comment:

Hello, I am trying to reference the current cell that I'm on (for a macro). I need to have it display the current cell such as in D8; I currently have it set to =D8. I want to have some way to make it for all cells that I'm going to copy over -- something like =ActiveCell.Worksheet so it will display the current cell and reference itself. Any ideas?

Reply:

Have you looked at the functions CELL, ROW, COLUMN, and OFFSET? =CELL("address")

0

Name: rhawk7938
Date: June 2, 2006 at 10:45:32 Pacific

Reply:

Code for worksheet: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Range("D8") = ActiveCell.Value End Sub

0

Name: A Certain TH
Date: June 8, 2006 at 04:57:45 Pacific

Reply:

the VBA version of CyberSlugs response is Activecell.Address Tom

0

Access to Outlook (2000 a...

config microsoft outlook ...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Hi, I need help in cell reference. I have a range of data in 20 columns in 30 rows, with data in each column being unique. All the columns have a defined name to identify the range of data. If I c...

Summary: How can you set Excel 2003 to highlight whichever cell is currently chosen? The way it is set now, I have a white highlight around the current cell, but I use spreadsheets with LOTS of text, so ofte...

Summary: I know how to use an IF statement to change the value of a cell in MS Excel (Office XP). But can the color of the text be changed also? Or the background fill? ...