Link to home
Start Free TrialLog in
Avatar of Rayne
RayneFlag for United States of America

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
Avatar of Brian Pierce
Brian Pierce
Flag of United Kingdom of Great Britain and Northern Ireland image

Its referring to cell A:1048576 on a sheet called sheet1
SOLUTION
Avatar of Brian Pierce
Brian Pierce
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Rayne

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
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Rayne

ASKER

Thank you all :)