View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mac Lingo[_2_] Mac Lingo[_2_] is offline
external usenet poster
 
Posts: 53
Default Changing Cells, How to

How do I change a cell value from my VM Macro?

I think this should do it
CELLS(4,4) = "NEW VALUE"
but it doesn't seem to.

I've also tried
ACTIVECELL.CELLS(4,4) = "NEW VALUE"

What am I missing? I'm sure it's obvious, but I can't figure it out.

Thanks,
Mac