Jim,
can you help me out with something, what dies the 24 stand for in this. I pasted this code in and it doesn not work.
Can you help. Do I need to name the range with z. Like Reports.Range("x3:x1000").Name = "z" for this to work.This is what I have, it sorts the PO # first then I want it to...
I ahve a spreadsheet that I need some help with the code please. I have PO numbers in column P, and in coulmn X I have pulled the first 2 letters out with =LEFT(X3,2).
I am wanting to delete rows of information based on the contents in X.
the range of cells is X3:X1000
I want to delete rows if...
not really sure what you are trying to do with Excel, but, yes Excel will automatically go to the cell after you enter a number.(ex:a23 you enter 3, hit enter and it will go to A24) not sure if this is what you are talking about..
To do this ,
go to Tools, Options,Edit, move selection after...
Excel will write the Macro to the file.
hit Alt and F8, this will bring uo the Macro dialog box,
now look at the box where it says Macros In.
This is all the open workbooks that you have that have macros in them. Make sure that you are not saving macros in the Personal.xls workbook..
most...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.