Insert TEXT down to last row of data using VBA?

evenyougreg

New Member
Joined
Oct 1, 2020
Messages
10
Office Version
  1. 365
Platform
  1. Windows
Hello,

I am simply trying to insert the text "accepted" into every cell of column B AND C (I know this may seem weird but it's what I need), until the last row of data in A.

I have some VBA code to achieve this with a formula, but in this case I only need text.

I would like to avoid copy and pasting, because the text is not there to begin with. Let me know if I am not being clear enough.

Any help would be appreciated! I am brand new to this forum:)

Greg
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,553
Office Version
  1. 365
Platform
  1. Windows
How about
VBA Code:
Sub evenyougreg()
   Range("B1:C" & Range("A" & Rows.Count).End(xlUp).Row).Value = "Accepted"
End Sub
 

evenyougreg

New Member
Joined
Oct 1, 2020
Messages
10
Office Version
  1. 365
Platform
  1. Windows
How about
VBA Code:
Sub evenyougreg()
   Range("B1:C" & Range("A" & Rows.Count).End(xlUp).Row).Value = "Accepted"
End Sub

This worked exactly as I needed.

I would likely have been ridiculed on Stack Overflow for asking this question, so I thank you!!
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,553
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,606
Messages
5,625,765
Members
416,136
Latest member
senthil_sk

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top