Laura,
Unless I'm misunderstanding, a chart can be copied/linked between Excel and Powerpoint as well as an individual (or group) of cells (your summary).
After you copy the chart/cells in Excel, use the small down arrow below the Paste in Powerpoint. Click Paste Special. Click the Paste...
Has anyone else noticed that the color schemes for Tables created in 2010 are different than those in 2013? From what I can see, the grey and blue (first and second styles) in each color grouping (1-7, 8-14, 15-21, etc) are the same; the remainder are a little off (2010 red vs 2013 orange =...
That's not really working. When I paste it directly, the text is red (presumably missing a " somewhere? o_O
My apologies; I should have paid better attention to the source (VBAExpress.com), as it was there the whole time.
Final code:
Hyperlink_dynamic = "=HYPERLINK(""[" & strPath &...
I'm stuck in how to replace a term with the appropriate VBA code. The goal is to have a dynamic hyperlink that changes not only anchor but also the Display Text. I realize the code as it stands is circular, but I can figure out how to make it work if I could only get the syntax correct.
The...
From the SpreadsheetGuru, I like this code because it evaluates the whole range at once.
However, given the forced xlCellTypeConstants, it will convert any formula into a value. The function can be run from the Immediate window if desired.
Public Function trim_all(gnr As Range)
' ~~ Trim |...
Using some work from p45cal, I posted a question like yours recently. Please note, there is one correction that I've incorporated in the code below (recent post).
Apologies if I've left any subs out; I use a lot of custom subs and rather than include all the extras, I try to post using generic...
Close, except it removes ALL spaces (3rd function in #3); but I think I like Cyberdude's solution better.
Nice solution to the re-arranging of columns using arrays, btw; very slick!!
p45cal came up with an awesome response to this question in 2015 (response #5).
However, I can't seem to get it to work; I thought it was working earlier but I believe had suppressed the error or hadn't noticed it. Below is the code I adapted from his.
At the line where With...
I'm spit-balling here, but I'm curious if you changed your statement defining ClaimRef to this perhaps it might help:
ClaimRef = Worksheets("Working File").Range("I1").value
Although, I think Chihiro was right -- if you step thru the code, on the second iteration, does the cell update to the...
Marc L,
Thank you so much! That works perfectly!
Could you help me understand how it works? I'm not familiar with scripting dictionaries. I understand the array loop and the SPLIT function (I wasn't aware of the limit parameter before) but the .ITEM(SP), JOIN(.ITEMS), .REMOVEALL, and tests...
I appreciate the input, but I guess I haven't made my need very clear. I am NOT in need of code to extract the filenames (although that is helpful in its own right). Instead, I'm looking for a way to identify the maximum with each group (latest time in each day)
Tushar provided a method to...
xlstime,
Thank you for the file. Unfortunately, it' doesn't address my primary issue - how to identify the last file of each day. Since I have almost 1000 files, manually going thru the list is what I hoped to avoid.
I was hoping someone could help me understand how to parse the time/date...
I posted this at Mr. Excel but no one was able to provide what I was looking for. I'm hoping that folks here might have some ideas.
I create a timestamped backup of my Personal.xlsb (filename & "_yyyymmdd_hhss") everytime I save it. As you can imagine, this leads to a lot of versions each day...
The scenario is that I'm looking within the header of a table/range and I need to identify each column so that I can apply various formatting/validation rules. The intent is that there only one header cell that contains any one of the listed criteria; it's up to me to ensure that there wouldn't...
1. Thanks
2. If I had three search criteria, how would the x formula change? Would I just have to add the additional criteria to the Array or would other changes be required as well?
x = Filter(Application.IfError(Application.Match(Array("CRITERIA1","*CRITERIA2", "CRITERIA3"), rngHeader, 0)...
@Deepak, thanks for moving my question. I had thought of nested tests, but had shyed away. Appreciate the knowledge that that's an alternative, though.
@jindon, thanks! Two questions: 1) is the variable 'x' a Variant (in the interest of Option Explicit) and 2) my original example listed the...
I originally asked this question at MrExcel but got no takers so I thought I'd try here.
Using VBA, I need to find the .address of the cell within a header (rngHeader) that contains either "DoB" or "Birth*" ([Birth* = Birth or Birthdate or Birthday]; I'd like the seach/match to be...
I took a look at how it's being pasted in Word (Options, Advance) - plain text! (which leads to spagetti) Once I changed to the Word defaults, it's now behaving; it loses indentation, but that's window dressing.
So, I can copy into Word, but Outlook is still garbage; oh well.
Look ma, no...