Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Set Column Names of Excel dynamically

Anonymous
Not applicable

‎18-09-17 02:44 PM

Hi, I would like to change column names in excel dynamically. Iteration through row seams to be easy but columns in Excel start with alphabet letters. I changed reference style for R1C1 in Excel and in set cell value action (MS Excel VBO) in cell reference I input expression: "R1C"&[CounterDate]&"" I am getting following error from this stage: Exception from HRESULT: 0x800A03EC Could you help? Monika
0 Likes
1 REPLY 1

Deep.Shah
Level 6

‎18-09-17 06:33 PM

With A1 reference style, you could try using ""Go To Next Cell"", it moves a specified number of Rows and Columns from the currently active cell and returns the new cell reference.
0 Likes