Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop code problems
Hi, i am using the following code to place the letters EA in column
for some reason it places it in colum n o p q r s? Can so one help the code am using is set myrange = Application.Selection for each cell in myrange cell.offset(0,13).Value="EA" Nex -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop code problems
Hi
depends on your selection as you use offset for this. try replacing the line cell.offset(0,13).Value="EA" with cells(cell.row,"N").value = "EA" -----Original Message----- Hi, i am using the following code to place the letters EA in column N for some reason it places it in colum n o p q r s? Can so one help the code am using is set myrange = Application.Selection for each cell in myrange cell.offset(0,13).Value="EA" Next --- Message posted from http://www.ExcelForum.com/ . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop code problems
Hi, i am using the following code to place the letters EA in column N
for some reason it places it in colum n o p q r s? Can so one help the code am using is set myrange = Application.Selection for each cell in myrange cell.offset(0,13).Value="EA" Next for example: Cells(cell.Row, "N").Value = "EA" or: cell.Offset(0, 13 - cell.Column).Value = "EA" -- Regards Melanie Breden - Microsoft MVP für Excel - http://excel.codebooks.de (Das Excel-VBA Codebook) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro loop problems | Excel Discussion (Misc queries) | |||
Loop for VBA code? | Excel Worksheet Functions | |||
How to Loop some code | Excel Discussion (Misc queries) | |||
VB for excel, how do I loop through code | Excel Discussion (Misc queries) | |||
If... Then Loop problems in Worksheet Event | Excel Programming |