rangeb1.value

Hi I wrote a code to swap 2 cells. Can I swap 2 selected cells/ranges instead of hard coding the way I did it. Thank you so much Sub myswab() Dim tmp As Double tmp = Range("a1").Value Range("a1").Value = Range("b1").Value Range("b1").Value = tmp End Sub

I recently created a spreadsheet that will notify me of upcoming offsite meetings by two weeks. Here is a partial code With OutLookMailItem .to = MailDest1 .bcc = MailDest2 .Subject = Range("a1").Value .Body = Range("B1").Value I like the subject line to include the...

Hi. Can u guys help me with changing a litle bit this macro code? It's works but when I try to change it for multiple IF nothing happend.. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("B1").Value = SKD Then Columns("C").EntireColumn.Hidden = True Else...

Hi, I am using this code to auto filter across different sheets. Could someone help make it more efficient please? Private Sub Worksheet_Change(ByVal Target As Range) <code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;">' On Error Resume...