gives the address and type of formula if the active cell contains a formula Free Excel Macros (VBA) | Excel Programs

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Excel Free Macros (VBA)

Gives The Address And Type Of Formula İf The Active Cell Contains A Formula

Online Excel and Excel Macro (VBA) Courses

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php

Sub ListFormulas()
    Dim counter As Integer
    Dim i As Variant
    Dim sourcerange As Range
    Dim destrange As Range
    Set sourcerange = Selection.SpecialCells(xlFormulas)
    Set destrange = Range("M1") 
    destrange.CurrentRegion.ClearContents
    destrange.Value = "Address"
    destrange.Offset(0, 1).Value = "Formula"
        If Selection.Count > 1 Then
            For Each i In sourcerange
                counter = counter + 1
                destrange.Offset(counter, 0).Value = i.Address
                destrange.Offset(counter, 1).Value = "'" & i.Formula
            Next
        ElseIf Selection.Count = 1 And Left(Selection.Formula, 1) = "=" Then
                destrange.Offset(1, 0).Value = Selection.Address
                destrange.Offset(1, 1).Value = "'" & Selection.Formula
        Else
                MsgBox "This cell does not contain a formula"
        End If
    destrange.CurrentRegion.EntireColumn.AutoFit
End Sub

Report problem with this macro

Report error

ALL MACROS

Youtube Channel
The following macros may be useful for you.

Similar Results
No	Macro Name
1	gives the address and type of formula if the active cell contains a formula
2	excel operators hk
3	Undo cells with 0
4	records detailed formatted cells on the records sheet / page
5	list formulas on new sheet / page
6	specifies in detail how many formulas are in the book (on new sheet / page)
7	write the days of this month to the right write the day to the child cell and color the weekends
8	a cell with a formula
9	add icons menus and buttons to the sheet / page
10	pushbutton pictures
11	adding two lines and removing total
12	inserts months as sheet / pages Specifies days in detail
13	printing and prompting
14	Find and select the remaining cell in the value between 2 selected numbers
15	Adding Rows and Total Formula When Cell Changes
16	right mouse on active sheet / page menu
17	finds formulas on active sheet / page lists new sheet / page
18	double-click on active cell to add subtotal
19	entering formula with message box
20	finding the type of active cell

Excel Free Macros (VBA)

Gives The Address And Type Of Formula İf The Active Cell Contains A Formula

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords