Solve : VBA (Excel 2000): using Cells(row, col) instead of Range("A1")

1.	Solve : VBA (Excel 2000): using Cells(row, col) instead of Range("A1") in a Formula?
Answer» HI guys, just need a relatively simple way to convert a Range to a CELL value for Formulas. EG. "=SUM(D3+D4)" INTO "=SUM(Cells(3,4) + Cells(4,4)" ' possible? The reason is i have soft-coded the column numbers into something like 'LastColumn', and 'rowCounter', which is useless if i'm forced to use Chars. any advice would be much APPRECIATED I'm having some DIFFICULTY making sense of your post. First, your title doesn't make sense. You SAY, "instead of Range("A1")", but A1 is not a valid range name; it is a cell address and all cell addresses are based on row and column. You can name a range and then use that range name in a formula instead of a cell address. Maybe that's what you're asking about. For this to work, I believe the range name would have to refer to a single cell, not a range of cells.

Discussion