$$Excel-Macros$$ Need help regarding entering date

Hi All, In excel 2003, I want to add time in HH:MM:SS format and I tried it by changing the format cell with Time in that format but whenever I use the shortcut for entering time in the Cells, it doesn't show the change of seconds. The shortcut I use for Time is Ctrl + Shift + ; keys. If there is

$$Excel-Macros$$ Need a function or formula

Hi All, I need your help in extracting some words (having defined format) from one cell in another cell. Attached is a sheet where I have mentioned the case and the solution I require. Hope you will help me. Best Regards Pooja Sharma *** --~--~-~--~~-

$$Excel-Macros$$ Re: Count Rows Where One Cell Has Value And One Cell Is Blank

Hi Dinsdale, Why not use the Count and Counta function, something like: =COUNT(A$2:A$65552) -COUNT(H$2:H$65552) depending on the data type of your client number, you may need to use counta instead of count. Good Luck, KevinSS On Oct 29, 12:04 pm, Dinsdale wrote: > Hello Everyone, > > I have a

$$Excel-Macros$$ Re: need macro help

*hi dear please send attachement * On 10/31/09, karthikeyan wrote: > > > hi, > I put a validation in one excel worksheet .This worksheet doesn't > allow paste values from any worksheet/workbook. > tks > karthik > > > > --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ need macro help

hi, I put a validation in one excel worksheet .This worksheet doesn't allow paste values from any worksheet/workbook. tks karthik --~--~-~--~~~---~--~~ -- Some important links for exce

$$Excel-Macros$$ Re: Macro for providing Multiple Passward in a single worksheet.

Place this code in the VBA module for the worksheet you would like to restrict and give it a try (needless to say: for this password strategy to be bullet-proof you would have to password-protect the VBA project, so that none uf your users can have access to the passwords): Const RANGE1_PWD = "ab

$$Excel-Macros$$ Re: For Excel Book

John Walkenbach's "Excel VBA Programming for Dummies' (this is not intended as an insult. it's REALLY a great book to get started): http://spreadsheetpage.com/ Hope this helped, Rolf On Oct 29, 10:42 pm, khalid khan wrote: > Dear friends > > Please suggest me book for Excel and VBA coding > > t

$$Excel-Macros$$ Re: Macro required for consolidation

Place this code into a standard VBA module of your workbook XYZ.xls and give it a try (you will still need to add a button that invokes the macro, and I would suggest to let the user decide where to save it by using the standard File | Save As command) : Sub ConsolidateFilesIntoMasterWorkbook()