RIGHT Function With Concatenate (?) VBA-Need Help with Macro

rsrasc · #3 08-22-2018, 09:50 AM

Quote:

Originally Posted by Kenneth Hobson

=right(b4,5) & " " & c4

Hi Kenneth,

Thank you for your response. I already tested this formula but I'm looking for a macro that when I run it it's going to apply it to 16 sheets in the file. I recorded a macro and this is what I got.

Code:

 
Sub Macro1()
'
' Macro1 Macro
'
'
    Range("A4").Select
    ActiveCell.FormulaR1C1 = "=RIGHT(RC[1],5)&"" ""&RC[2]"
    Range("A5").Select
End Sub

But I don't like it.

Will see if someone can come out with a better option.

Thanks anyway!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Concatenate function for displaying numbers in words	officeboy09	Excel	13	08-09-2021 12:59 PM
Adding a function to this macro:	JohnGanymede	Excel Programming	6	12-22-2017 02:57 PM
How do you write a macro with an IF Function	Scheuerman1987	Excel	5	06-05-2013 06:04 AM
Macro or user function to Extract row height	Catalin.B	Excel	12	06-22-2011 09:21 AM
Help! for using an appropriate function/Macro in Excel	pawan2paw	Excel	1	06-04-2009 12:28 PM