Tag Info

New answers tagged

0

Found out. I just need to do, etc if I want to copy from Image1 to Image2, Image1.Picture = Image2.Picture.


1

Yes, it's possible if you use Excel Named Formulas. For instance, suppose that you need to calculate the difference between the sums of two consecutive columns (A5:Ax - B5:Bx) in different places in your workbook (x is the final row of the each column): So you define in A11 a name called diff (any name can be used) as =Sum(A$5:A10)-Sum(B$5:B10), assuming ...


0

I know you said no VBA, but doing as follows does NOT require you actually re-write your formulas, know much about VBA, nor maintain your formulas in VBA. You can write it once and forget about it. Create a User-Defined Function to extract the formula from a cell as a string: Function GetFormula(Target As Range) As String GetFormula = Target.Formula ...


0

The only way you can make custom functions in Excel is through VBA. I've experimented with this a long time ago, and it really is not that hard. It will become a problem if the formula is between different sheets. If its all in the same workbook, the function can be embedded in that workbook. What you might want to look after is defining custom ranges. If ...


0

Select ColumnA, HOME > Styles - Conditional Formatting, New Rule..., Use a formula to determine which cells to format, enter: =$A1<>"" in Format values where this formula is true:. Select Format..., apply Border (top border), OK, OK. Ensure Applies to is set to =$B:$E, OK.


2

I've seen variations of this question before, but can't find any now so figured I'd ask and answer it. I wrote this VBa to resolve the issue! Now when I click send, if I'm sending from a specific account it will look through the 'do not send to list' and then prompt me to either cancel or continue. This means it's wonderfully non-invasive! And even if I ...


1

Okay, I'm sort of confused at your VBA example, but the best way to do this is to multi-select all the pictures, right click - assign macro. This will assign the same macro to all of the selected pictures.


1

Well, it doesn't seem like you've put any effort into this, but since I already have these macros written, I'll supply them for anyone else that is searching. These were written in excel 2007 and were part of a larger process. It is important to note that this will fail if any of your file names have over 31 characters, excel has a character limit for sheet ...


0

Sendkeys commands as suggested by other answers are not encouraged. In the past Sendkeys command resulted in very unexpected actions, to where you may have to reboot computer to recover. I would recommend making the routine local and execute it on-demand only. For convenience you can also assign a cntl key to it like "q". The Workbook Within option will be ...


4

Didn't mean to answer my own question but I found out how to do it afterwards. So here's the deal: First, make a copy of the file, rename it as .zip, open it and navigate to [zipfile]\xl\worksheets\ There you'll see the .xml files with their uncompressed size. For instance: Identify the biggest worksheet, in this case sheet6.xml Open the file ...


1

A 47 NB xlsx file is very uncommon unless it has lots of images in it. If yours hasn't, the chance is big that you are having one of those exported files that gone wrong. Basically what happens is that when the xlsx file is exported, opened with excel and then saved again, it saves the file with lots of empty rows and columns. You can identify this by ...


0

I solved it myself. ' Copy week & name to all rows For i = 1 To ActiveSheet.UsedRange.Rows.Count - 1 Step 1 If IsEmpty(ActiveSheet.Range("A" & i + 1)) Then ActiveSheet.Range("A" & i).Copy Destination:=ActiveSheet.Range("A" & i + 1) ' Week End If If IsEmpty(ActiveSheet.Range("B" & i + 1)) Then ...


0

Yes. Give each image the same name, and a different index. You can now refer to this object as a whole collection and select an image by whatever index is given.


0

There are 2 ways to approach this problem. Create a form with all the controls on it, including the image (this would be the easiest way) Place an image control directly on the excelsheet, along with other controls (this is prone to users causing to delete the content. If you go for option 1, From VBA, create a new form and draw your controls on there. ...


1

I used this link: http://peltiertech.com/Excel/Charts/AlignXon2Ys.html ' Helper Macros Sub AlignY_PrimaryMinimum() AlignY 1 End Sub Sub AlignY_PrimaryMaximum() AlignY 2 End Sub Sub AlignY_SecondaryMinimum() AlignY 3 End Sub Sub AlignY_SecondaryMaximum() AlignY 4 End Sub ' The Main Event Sub AlignY(FreeParam As Integer) '' FreeParam: AXIS ...


1

You could do that using something along the following lines (I haven't tested this exact code, so expect errors) Sub openAndProcess1Document( FullName As String, target As Word.Document ) ' FullName is the full path+file name of the .docx ' target is a reference to the document that was the ' ActiveDcoument before you call this routine ' Or you could set up ...


0

Would this work? Sub RescaleSecondaryAxis() Dim PriMax, PriMin Dim SecMax, SecMin ActiveSheet.ChartObjects("myChart").Activate ActiveChart.Axes(xlValue, xlPrimary).Select PriMax = ActiveChart.Axes(xlValue, xlPrimary).MaximumScale PriMin = ActiveChart.Axes(xlValue, xlPrimary).MinimumScale SecMax = PriMax SecMin = PriMin ...


1

After reading through all of the comments and finally figuring out what you were trying to do (I think)... I believe the following UDF will work. Stick this in a new module in VBA and then in whatever cell you want to display the result type =summarizeLog() and hit enter. Function summarizeLog() As String 'Define some variables Dim shtLog As ...


1

Answering my own question since I found a solution/workaround. I moved the macros to a module (from thisdocument), and that solved the problem. Now I can use activedocument. For future reference, if you need to access a new document based on a template from a macro stored in thisdocument in the template (such as document_new), you need to embed the code in ...


0

http://numbermonger.com/2012/02/11/excel-pull-function-creating-dynamic-links-to-closed-workbooks/ The Link above vcould be a good option. Didn't had the time to test it myself.


0

You have to use VBA to extract the data. Here's one possible VBA solution: http://peltiertech.com/WordPress/extract-chart-data/. It includes this code: Sub ExtractChartData() Dim iSrs As Long Dim cht As Chart Dim srs As Series Dim ws As Worksheet If ActiveChart Is Nothing Then Exit Sub Set cht = ActiveChart Set ws = Worksheets.Add ...


0

You have two options that involve rewriting your VBA code. First option: whenever accessing the Range.Formula property, replace it for the Range.FormulaLocal property. The localized version of the formulas will be translated by Excel into the English version it uses internally. Range.FormulaLocal documentation: MSDN Range.FormulaLocal Property (Excel). This ...


1

I know you've answered your own question here, and it is helpful, but for people wanting to transfer an old personal macro workbook from an Excel 2007 and below, to Excel 2010, they should copy %APPDATA%\Microsoft\Excel\XLSTART\PERSONAL.XLS to the same location on the new machine, without renaming it XLSB. Depending on the version of windows, %APPDATA% ...


1

You know how to do it will cells in a range, you just append the .entirerow to the end of the range e.g.- Cells(1,1).EntireRow.Interior.Color = 6



Top 50 recent answers are included