Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell reference
I have several sheets in a work book that need a range of cells deleted
before inputting more data. The range to delete is A15 to D540. Then I need it to go to the next report and do the same, This would happen up to 20 times as there are up to 20 reports in the workbook. Just to make this harder, The worksheet names will be renamed as users determine different names. I have basicly created a "Template" reporting tool that will allow different departments to use it, simply by changing the tab names and keeping track of the changes on the list (below) I created a list of sheet names on a tab called "Calculations" in range J2 to J 22 and would repeat the routine up to 20 times, one for each tab required. If I use this routine, it works, but the reference to the sheet name would have to be edited in the macro every time the tab is renamed. *********** Sheets("Finance").Select Range("A15:D540").Select 'ActiveWindow.SmallScroll Down:=-60 Selection.ClearContents Range("A1").Select ******************* The name Tab named Finance would have to be renamed each time the tab was renamed. I tried the following to reference the list , but it is not working. **************** Sheets (Range("J2").Value).Select Range ("A15:D540").Select 'Active Window.SmallScroll Down:=-60 Selection.ClearContents Range("A1").Select ***************** I wouldlike to runthe macro from one sheet and have it run through each sheet, then retun to the starting sheet. Do I need to reference the workbook name? Any suggestions? I could use some help here as I have a great tool developed and this is the final hold up (I hope) Peter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing sheet reference to cell reference | Excel Worksheet Functions | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |