I want a msgbox that prints the values of A1 to j1 where j is a variable constrained by the number of columns. I created a formula to count the number of columns and called it ncolumns. now i just need the proper syntax to type from a1 to j1