...
...
Menu Bar > Insert > Name > Define...sey select box ka name change kar sakte he...try it....
yaar k say?
From
Salman
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
macro ka use kerna examples k sath batain Mr. Website working(jibran)
cooooooooooooooool
Bookmarks