Programming help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new to access so I need some help with this. Cell a =equals a date say
5/15/80 cell f = 5/15/06. If cell a is greater than or equal to cell (F-6574)
than place an X in cell I.

dim rcell as range
for each rcell in range( _
range("a:a"), _
if rcell.value=>formular1c1(F-6574)
rcell.paste rcell.offset(3,1)
end if
next rcell

I dont think this would be right but am I close?
 
This news group is for Access. I think you will get a better answer in an
Excel news group.
 
I thought access and excel macros are similar in coding thats why I pasted
here, I also pasted in excel. Thanks.
 
VBA is the same accross all Microsoft Office applications; however, the
object models are all different. For example, I don't really know what
formular1c1(F-6574)
means.
 
Back
Top