Try something like this:
Sub Macro1()
Dim sheetnames As Variant
sheetnames = Range("C1:C10").Value
For i = 1 To UBound(sheetnames)
If sheetnames(i, 1) <> "" Then
Sheets.Add After:=Sheets(Sheets.Count)
ActiveSheet.Name = sheetnames(i, 1)
End If
Next i
End Sub
On Mar 19, 9
sn't keep. as soon as you close the dialog box
it goes back to what it was.
On Mar 18, 12:08 pm, Michael wrote:
> It should tell you which cell contains the link. Go to it and delete
> it. You will need to hard code the data.
>
> On Mar 17, 3:31 pm, "~slacker~" wrote:
&
rd code the data.
>
> On Mar 17, 3:31 pm, "~slacker~" wrote:
>
>
>
> > I need help in breaking data links to other excel workbooks. The excel
> > workbook I am using (excel 2007) has links to other workbooks that can
> > been seen by going to Data -> Edit Li
with Excel 2007 the Help options seem to be much better. Along with
this a pretty extensive list of shortcut keys
http://office.microsoft.com/client/helppreview.aspx?AssetID=HP100738481033&QueryID=2M8Hx7LZd&respos=5&rt=2&ns=EXCEL&lcid=1033&pid=CH100947761033
some of my favorites:
CTRL+SHIFT+END e
I need help in breaking data links to other excel workbooks. The excel
workbook I am using (excel 2007) has links to other workbooks that can
been seen by going to Data -> Edit Links
One of the links listed here does not point to a valid workbook and I
would like to break the link to get rid of the
Your example is somewhat confusing but if you just want to copy
formats have you tried right click -> paste special -> formats?
or the 'Format Painter' which in excel 2007 is on the Home ribbon near
cut/copy/paste buttons
On Apr 9, 6:09 pm, KARTHIKEYAN B wrote:
> Hi,
> Can you help me on this fi
This seems like it should be fairly straight forward but i can't seem
to find an easy solution.
Can any one help?
I want to create a macro or hot key that will take the formula in the
currently selected cell, copy it to the cell below and adjust the
formula 3 columns to the right.
ex.
if the sel