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!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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