Making a macro linking two range more efficient.

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Making a macro linking two range more efficient.

FAQ

Thread Tools

Display Modes

03-13-2024, 08:26 AM

p45cal

Windows 10 Making a macro linking two range more efficient.

Office 2021

Expert

Join Date: Apr 2014

Posts: 956

try:

Code:

Sub blah()
Dim rng0 As Range, cll0 As Range
Set cll0 = Selection
Set rng0 = Application.InputBox(Prompt:="Select source range", Type:=8)
rng0.SpecialCells(xlCellTypeVisible).Copy
Application.Goto cll0
ActiveSheet.Paste Link:=True
Application.CutCopyMode = False
End Sub

Tags

link, visible

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help making a Macro	Mullin4414	Word VBA	4	03-06-2023 09:17 AM
Problem with efficient organisation of pictures in my pub	Croitz	Publisher	0	12-22-2018 05:48 AM
Linking Range of Cells in a Row	friesjh	Excel	5	06-28-2016 10:22 AM
Most efficient way to store numerous charts?	RAB	PowerPoint	0	07-13-2015 07:17 AM
Macro Question: Need help making a macro to highlight the first word in every sentence	LadyAna	Word	1	12-06-2014 10:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:52 AM.