Cell Range problems

  • Thread starter Thread starter Greg85374
  • Start date Start date
G

Greg85374

Hi this is a first post..im an intermediate Vb programmer...Here's m
Dilemna.....


I have an excel spreadsheet...I used variable(CurRoxX) to store the ro
the user clicked on I statically assigned a variale to
colum(CurColY)..I set CurCollY = "8" or should i use "H"?...now whe
the user selects and fills in all information required in a row...
want to move to column 8 or H in that same row and input a datestamp.
Can anyone help me. The problem is i cant concatente using a quot
inside quotes to store the XY position and I dont know how to refer t
a cell through strings..Thanks in advance i hope i was clear enuff t
understand.:confused
 
Greg,

I think ...

CurColY = 8
Cells(CurRowXS, CurColY).Value = Date

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Greg,

You can use a variable dimension as a Long for rows, and one as an Integer
for the column

Sub TryNow()
Dim CurRowX As Long
Dim CurColY As Integer

CurRowX = 3
CurColY = 8

Cells(CurRowX, CurColY).Value = Now

End Sub


HTH,
Bernie
MS Excel MVP
 
That was an excellent response..i have been trying to refer to a cell
address using activecell instead of cell()..Thank u very much..
 
Back
Top