Rayne
asked on
Excel stupid question
Hello All,
Sure enough I am not sure what i am doing ...playing with a bunch of formulas :( done by someone esle...
What does this mean?
Sheet1!$1:$1048576
Sure enough I am not sure what i am doing ...playing with a bunch of formulas :( done by someone esle...
What does this mean?
Sheet1!$1:$1048576
Its referring to cell A:1048576 on a sheet called sheet1
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Couldn’t get that? It is referring to 1048576 columns across starting from column A? or what it is the row starting from row 1 all the way to 1048576th row? Across or down….please explain
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you all :)