Macro for a selected data

[bombur10]

Hi, I want to run a macro where I want to be able to see a certain range of data in a print preview. My problem is, let's say I move the data over somewhere else, I want the macro to follow the data and not stay at the previous range. Does that make sense? Thanks

 

[agihcam]

Hi -
Welcome to the board.
try this;
Select the range > Insert > Name > define and named it as "test"
then write a macro like this;

sub followdata()
range("test").printpreview
End Sub

 

[bombur10]

what happens if the area of data I want to select are from two separate places. How can I select the stuff I want to see in print preview? Thanks

 

[agihcam]

select the first cell, hold Ctrl key then select the other cell, then define the name as previously instructed, then run this code;

Sub followdata()
Range("test").Select
ActiveWindow.SelectedSheets.PrintPreview
End Sub

 

[bombur10]

Well if I record a macro, it gives me this:
Sub Macro5()
'
' Macro5 Macro
Macro recorded 9/21/2006 by xxx

How do I put your part in afterwards without the sub part? It won't let me do it twice. Thanks

 

[bombur10]

Okay I think I'm supposed to find the region that I defined. So if I defined a region and called it ("Test"), how do I select the region and make it my currentregion? This way if I move the data ("Test"), I still want to print preview the data and not the wrong region. Thanks people