Need Help with a spread sheet.

[Brian12q34]

I have a spreadsheet that has 7 columns of URLs and i need to place a double hash tag between each URL row a is my mpn row b is my image name row c is the first set of URLs row d is for the (2) ## hash tags row e is my second set of URLs row f is for 2 hashtags row g is my third set of URLs row H is 2 Hashtags Row I is my 4th set of URLs row J is for 2 hash tags row k is my 5th set of URLs Row L is for 2 hash tags row m is two hash tags row n is my last set of URLs. I am looking for a command to tell excel that if their is a URL in the Row to the right to place 2 hash tags next to it . see example i have 115607 rows. Thank you Howard

[TABLE="width: 3951"]
<colgroup><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Item #[/TD]
[TD]Image name[/TD]
[TD]URL to large image[/TD]
[TD]##[/TD]
[TD]Extra Img 1[/TD]
[TD]##[/TD]
[TD]Extra Img 2[/TD]
[TD]##[/TD]
[TD]Extra Img 3[/TD]
[TD]##[/TD]
[TD]Extra Img 4[/TD]
[TD]##[/TD]
[TD]Extra Img 5[/TD]
[TD]##[/TD]
[TD]Extra Img 6[/TD]
[/TR]
[TR]
[TD="align: right"]2758[/TD]
[TD]2758.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/2758.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/2758_26007992.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/2758_26007993.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/2758_26007994.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/2758_26007995.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/2758_26007996.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/2758_26007997.jpg[/TD]
[/TR]
[TR]
[TD="align: right"]5349[/TD]
[TD]5349.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/5349.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/5349_25904230.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/5349_25904231.jpg[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5659[/TD]
[TD]5659.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/5659.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/5659_25696155.jpg[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6652[/TD]
[TD]6652.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/6652.jpg[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6679[/TD]
[TD]6679.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/6679.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/6679_26339424.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/6679_26339425.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/6679_26339426.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/6679_26339427.jpg[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7104[/TD]
[TD]7104.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/7104.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7104_25711439.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7104_25711440.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7104_25711441.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7104_25711442.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7104_25711443.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7104_25711444.jpg[/TD]
[/TR]
[TR]
[TD="align: right"]7105[/TD]
[TD]7105.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/7105.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7105_25602039.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7105_25602040.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7105_25602041.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7105_25769868.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7105_25769869.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7105_25769870.jpg[/TD]
[/TR]
[TR]
[TD="align: right"]7157[/TD]
[TD]7157.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/7157.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7157_25715963.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7157_25715964.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7157_25715965.jpg[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7340[/TD]
[TD]7340.jpg[/TD]
[TD]http://www.imageserverhost.com/simg/C122/large/7340.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7340_25712591.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7340_25712592.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7340_25712593.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7340_25712594.jpg[/TD]
[TD]##[/TD]
[TD]http://www.imageserverhost.com/simg/C122/original/7340_25712595.jpg[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[DataBlake]

Sub MM1()
Dim lr As Long, c As Long
lr = Cells.Find("*", , xlValues, , xlByRows, xlPrevious).Row
For c = 4 To 14 Step 2
Range(Cells(1, c), Cells(lr, c)).Value = "##"
Next c
End Sub
Sub MM1()

it looks like you're trying to merge multiple macros?

i have no clue what this second macro is, but you have two subs named the same thing and that is probably generating the error
change the second sub to name MM2 or something

 

[Michael M]

Please repost the code using code tags...thats the hash sign in the reply toolbar.
The code I sent you doesn't error....but the code you have replied with probably does !!

 

[Brian12q34]

Thank you Michael M i was trying to run the same code twice. my Bad