Feb
28
awarded Popular Question
Sep
26
awarded Famous Question
Feb
23
awarded Notable Question
Sep
24
accepted Problems when using RANKX on PowerPivot
Sep
19
accepted Keep excel table formatting after refreshing the table
Sep
14
comment Convert text to columns in Excel using VBA
Thanks a lot Chris :)
Sep
14
comment Convert text to columns in Excel using VBA
Got it, one more thing and I'll leave you alone, this is only working when I'm in sheet2, (but the buttong is on sheet1), is there way to make it work if I click the buttong on Sheet1?
Sep
14
comment Convert text to columns in Excel using VBA
It seems that when I try to assing the new cell range and last column it crashes, Set rngCRM = [O6] Set rngCRM = Sheets("Sheet2").Range(rngCRM, Cells(Rows.Count, rngCRM.Column).End(xlUp)) rngCRM.TextToColumns Destination:=rngCRM, DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _ Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _ :=Array(1, 1), TrailingMinusNumbers:=True Issue comes exaclty on the part where we get the last column
Sep
14
comment Convert text to columns in Excel using VBA
I tried to add another block of code but now with rng2 = [D], and it's not able to do it :(, it wont let me capture the range of the new column
Sep
14
comment Convert text to columns in Excel using VBA
One more questions, if I needed to do this for 2 columns, let's say column A and B, could I do it in a cycle or I should run this procedure 2 times?
Sep
14
accepted Convert text to columns in Excel using VBA
Sep
14
comment Convert text to columns in Excel using VBA
That worked like a charm I just added the Worksheet("Sheet") no the range :), Thanks Chris
Sep
14
comment Convert text to columns in Excel using VBA
Hello CHris, I tried your solution but I got this error, "Microsoft Excel can only convert one column at one time ... ". Any ideas?
Sep
14
comment Convert text to columns in Excel using VBA
I have tried, but it only works if I only have something selected, I want to make the selection dynamic (A7:A50000? or even better A7:lastnonempty cell?)
Sep
14
revised Convert text to columns in Excel using VBA
added 392 characters in body
Sep
14
asked Convert text to columns in Excel using VBA
Sep
14
asked Keep excel table formatting after refreshing the table
Jul
9
answered How to change a attribute to a measure with DAX?
Jul
9
asked How to change a attribute to a measure with DAX?
Jun
29
comment Getting the top highest result from a set with MDX
This is exactly what I was looking for, that's a lot for the help!
1 2 3