Writing VBA for Inserting Text in a multiple cells.

[sirmacademy]

I want to insert in a cell a text "Saturday" and "Sunday" but I find it difficult to find the pattern inserting it.

Thank you for your help.

 

[sirmacademy]

Hi Jackdanice and Rcik, thank you very much for the code. But the code is running #value for the empty cell. Hoping you may give me another way of leaving it empty if its empty cell or no data. Thank you in advance.

 

[Rick Rothstein]

Hi Jackdanice and Rcik, thank you very much for the code. But the code is running #value for the empty cell. Hoping you may give me another way of leaving it empty if its empty cell or no data. Thank you in advance.

The second macro (named M3) that I posted in Message #9 did not work correctly for you when there were blanks???

 

[sirmacademy]

Sir Rick the M3 works, but it moves and add the column to the right.

 

[Rick Rothstein]

Sir Rick the M3 works, but it moves and add the column to the right.

Okay, so now I think we are back to my original confusion over your use of the word "insert". What is being inserted where?

Also, in what you wrote above... what exactly do you mean by "it moves"? What moved?

And what do you mean by it "add the column to the right"? The output from M3 went into Column C... you said in Message #3 "I want to insert in C3, C9 C10, C16 C17, C23 C24, C30 C31" (although you did not explain what you meant by "insert") so what was wrong with where I outputted my Saturday/Sunday text values.

 

[sirmacademy]

Sir Rick this is the sample format:
[TABLE="class: outer_border, width: 300, align: left"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Date[/TD]
[TD]am in[/TD]
[TD]am out[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2016-02-03[/TD]
[TD]07:30[/TD]
[TD]12:30[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2016-02-04[/TD]
[TD]07:45[/TD]
[TD]12:33[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2016-02-05[/TD]
[TD]08:40[/TD]
[TD]12:14[/TD]
[/TR]
</tbody>[/TABLE]








After the M3()

Sir Rick this is the sample format:
[TABLE="class: outer_border, width: 300, align: left"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Date[/TD]
[TD]am in[/TD]
[TD]am out[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2016-02-03[/TD]
[TD]Saturday[/TD]
[TD]07:30[/TD]
[TD]12:30[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2016-02-04[/TD]
[TD]07:45[/TD]
[TD]12:33[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2016-02-05[/TD]
[TD]08:40[/TD]
[TD]12:14[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]








May you help me again in solving this problem. I want it this way.
[TABLE="class: outer_border, width: 300, align: left"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Date[/TD]
[TD]am in[/TD]
[TD]am out[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2016-02-03[/TD]
[TD]Saturday[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2016-02-04[/TD]
[TD]Sunday[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2016-02-05[/TD]
[TD]08:40[/TD]
[TD]12:14[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]









Only Saturday and Sunday. No time after OUT
PS: Thank you Sir for the unending patience and help.