Thread: VB Code is working for row1; how to apply to row2?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bearacade[_43_] Bearacade[_43_] is offline
external usenet poster
  
Posts: 1
Default VB Code is working for row1; how to apply to row2?

The simpliest way of doing it would be:

For x = 1 To 100
Cells(x, 1).Select
(Your Macro/Fuction here)
Next x

This would select A1, B1, C1 and so forth

HT

--
Bearacad

-----------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...fo&userid=3501
View this thread: http://www.excelforum.com/showthread.php?threadid=57275

Reply With QuoteReply With Quote