(Help Plz)==>Menu Bar --> Insert --> Name ?

[*msalmanayaz*]

...

[oLd i$ gOlD]

Menu Bar > Insert > Name > Define...sey select box ka name change kar sakte he...try it....

[*msalmanayaz*]

yaar k say?

From
Salman

[syar]

Name ranges ko istimal karne k diffrent method aur approach hain. Simple one

Suppose agar aap column A main price lekhte hain aur column b main us ka Quantity.
column c main dono k total k leye aap =a1*b1 ka formula istimal karte hain.

But Agar insert===>define===>name==> k box main price aur refer to main column a ki range dain aur isi tarah aap clolumn b ko quantity ka name dain.

Tu ye formula istarah ho ga "=price*quantity" jis se samajhne main aasani ho gi.

Further tafseel k leye aap course k section main "Mubashir Aziz" k thread deekh lain. He explained named ranges beutifully. Its will be worth foryou in future.

regards

[friend4allage]

macro ka use kerna examples k sath batain Mr. Website working(jibran)

[Jaffary]

cooooooooooooooool