|
Feb
23 |
|
awarded | Notable Question |
|
Jan
3 |
|
awarded | Popular Question |
|
Sep
28 |
|
awarded | Popular Question |
|
Sep
24 |
|
asked | RANKX function ranking per each attribute in pivot table |
|
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? |
