View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default How do I select every 70th cell and put a symbol in it?


This is macro script to put inside a sub. I can't mail you an example
without your email. Mail me (address below) a workbook along with what you
want and I will return it.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"cbpfaff" wrote in message
...
I am not totally following your instructions. What is 'i' and what is 'a'?
Or better yet, can you email me an example?

"Don Guillett" wrote:

for i=1 to 685 step 70
cells(i,"a")=??
next i

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"cbpfaff" wrote in message
...
I want to have the program select every 70th cell and put a symbol in
it.
The population is 685 cells. Can excel do this with out me having to
move
and manually select?