PDA

View Full Version : Microsoft Excel

Pages : [1] 2 3 4 5 6 7 8 9 10
  1. Where to start?
  2. My Excel Read-Only file will not open in maximized view.
  3. Hide tabs from specific user(s)
  4. Conditional formatting on Change of Cell Value
  5. Find, Copy and Paste Macro Help.
  6. Lookup data
  7. Convert Data type
  8. Copying and pasting discontinuous cells
  9. Select active cell
  10. Wordsearch function
  11. Run a Macro when a cell is selected
  12. checking whether a value is within a range
  13. Vlookup and if
  14. Find Next Empty Row
  15. Calculation Issues
  16. Formula to return the decimal of a Value
  17. Format number as text on multiple files import to a Single Workbook
  18. rearrange columns in all the sheets based on column header
  19. Data Type Mismatch in Excel ODBC
  20. Child, Mother, Father
  21. String Function in Excel ODBC
  22. Data between dates
  23. Parsing text strings to words
  24. Charts Issue With 2 X Axis
  25. Refresh pivot on start-up
  26. Get Min & Max date from Pivot table field
  27. Compare values and move data to new sheet.
  28. CONCATENATE - limits?
  29. Set "Save As" file path
  30. Clear contents of cell if clicked, then repopulate if nothing is entered
  31. modify cell contets
  32. Generic DISTINCT question, but I'm querying XLS
  33. VBA form - search and export row
  34. Data/String into an Excel Cell using VB
  35. Check for a value in a cell - find match in sheet2
  36. If Function with Time Format
  37. If formula (Scratching my brain)
  38. Column counts w/Look up cells & #N/A
  39. Counting instances of specific value
  40. Creating individual logins for mulitple worksheets (VBA),
  41. Marco to hide blank rows
  42. Check boxes
  43. Find Duplicate; Copy; Paste
  44. is it possible to access/write database ms access 2003 .mdb at the same time?
  45. Excel links to TimeSlips (Paradox) and QuickBooks?
  46. VLookup to find data from filtered rows
  47. personal function
  48. Linking Access DB to Excel via MSQuery (VBA Question),
  49. Help on PivotTable..
  50. Subtract Datetime
  51. How to get current path then do the linking
  52. multiple rows of text from notepad
  53. SUM column totals when there's #N/A
  54. Forcing column datatypes, but allowing user entry
  55. Can't see message bar with security warning
  56. Replacing the False in vLookup with a Dash
  57. Macro to identify & consolidate same value cells
  58. Workday function to find specific date ?
  59. Minimising the Ribbon
  60. Using vba for custom formulas
  61. Excel SendKeys CTRL+TAB
  62. Insert file path in footer
  63. Code exection & Worksheet functions - synchronous or asynchronous ?
  64. Assigning Range - Relative reference Vs Worksheet reference
  65. Iterate Code Modules
  66. Egregious hyperlink behaviour
  67. Multi Page control
  68. Sendkeys
  69. Find records
  70. Help with Pivot Table - Source data & Calculated items
  71. Lookup array of values
  72. Reference Label on Worksheet
  73. excel game
  74. Excel VBA Function...Can someone explain this function to me?
  75. Convert Excel2007 database to Works 9.2 database?
  76. =SUMPRODUCT((Data1!$B$1:$B$500="March")*(Data1!$C$ 1:$C$500="New York"),(Data1!$E$1:$E
  77. conflict between auto save&close macro and show/hide sheets macro
  78. Excel error help
  79. number to string
  80. Tweeks to improve macro
  81. Please Help!!!!
  82. Basic excel query!
  83. MS Excell - Nested If issue -Amateur
  84. Horizontal axis stuck to 0 line
  85. Horizontal Match
  86. Opening an Excel file from network
  87. Query help
  88. Stop a Macro Running twice
  89. using offset?
  90. Long string in Excel cutting off in mail merge
  91. Data Validation Problem
  92. Print preivew from page # doesnt work
  93. Call up excell workbook from with DB through on Click
  94. pass values from excel worksheet to VBA array
  95. SUMIF function returns no result
  96. Tab Color If Statement
  97. how to insert null record in excel sheet
  98. CSV over 200,00 rows but Excel 2007 not importing
  99. Help with monstrous formula from H*ll
  100. UBound: Type mismatch in VBA function
  101. sorting data in more than 3 columns
  102. Restrict / Provide access to users to a macro through a sql database list.
  103. Userform in Excel with Remember Password and User id option or check button
  104. Bloomberg Copy Screen/Excel VBA Problem
  105. Create ageing periods (eg 0-30, 60-90 etc) Excel 2003
  106. if formula to check if the number is in a certain range
  107. Querying MS Access data from Excel
  108. Rowsource for userform in Excel add-in not working
  109. Income Oppertunities from Home
  110. Function to get the current path/directory
  111. returning a cell's address from the results of a VLOOKUP
  112. Formulas not updating for no apparent reason
  113. Selecting Subgroup based on specific Group
  114. Parse Name from one sheet to another
  115. CUMULATIVE COUNTIF...sorta
  116. userform cascading combo box
  117. macro to select row
  118. Getting dd/mm/yyyy mask to apply to an InputBox
  119. Date format problems in excel
  120. Adding numerical values of letters
  121. Problem with Move Selection After Enter
  122. Excel - Importing External Data
  123. DOS Command/Batch File: Syntax to call variables
  124. Prevent leaving Excel window while code runs
  125. referencing multiple worksheets
  126. Taking data from three workbooks combining into one workbook.
  127. Referencing External Workbooks
  128. Line Weight
  129. Filter a multi demensional array?
  130. VBA help on .AutoFilter results
  131. Open form to specific record, create new record if it does not exist
  132. Read Range values to array
  133. Excel Date conversion
  134. How can I stop this template from locking up
  135. Webbrowser Help
  136. help with Connection string for Progress 9.1D
  137. If statement to delete rows ending at last row
  138. Several macro files running at the same time - will it cause conflict?
  139. Get an instance of a sheet from codename string?
  140. Autofill Problem
  141. Set order of sheets in a work book
  142. Grouping and unGrouping colums
  143. create array from range of cells
  144. Count Multiple Columns
  145. Formula When Exported From Access Doesn't Work
  146. Need To Create Row Reference Not Knowing The Row
  147. Outer Join and Inner Join with 3 tables in MSQuery (Excel 2003) linking to Sage 50
  148. Printing with Named range faster than Address?
  149. Cycle cells in Given Range
  150. Excel Drop Down List
  151. How do you create a % format type?
  152. Excel 2007 Add-in to save DBF
  153. help in temp tables
  154. copy & paste
  155. VLOOKUP Problem
  156. determine if a sheet name exists
  157. Exporting data to Access using VB
  158. donīt manage to send an image backward ......
  159. Using a Userform to obtain value for use in macro
  160. Link a table to another table?
  161. MS Query using "contains" and "prompt"
  162. Convert number into text
  163. JOIN 2 WS into one
  164. Deleting Multiple Data
  165. Filter a multi demensional array?
  166. Month display on pivot, plus variance column
  167. Resizing an array
  168. Error 438
  169. Data validation depended on IF statement
  170. managing a payroll
  171. Any ppl can help on Database with user form
  172. Filter an collection of objects?
  173. Stop all code from executing
  174. Edit Record In Access from Excel Using VBA
  175. Trouble displaying access table in excel macro
  176. Comparing multiple values and counting if criteria meets
  177. loop control issue
  178. Excel IF and vlookup formulae
  179. Using error handling in excel
  180. Nonprinting characters
  181. INSERT INTO statement having local variable and SELECT statement as parameters in VBA
  182. All the code
  183. returning a variant matrix Subscript out of range (Error 9)
  184. using a matrix
  185. What to use for a string enum? Read only class?
  186. my 1st class what am i doing wrong?
  187. ISNULL? isnull(myArray(1,0),myArray(1,1)
  188. declaring a multidemensional array
  189. color fill
  190. GetSaveAsFileName Question
  191. Grab only numbers out of a text string (MS Access)
  192. Date/Time field export issue
  193. VLOOKUP Formula to return 0 instead of #N/A
  194. Macros
  195. Copy worksheets from multiple workbooks into specific tab in master
  196. Referencing an empty cell in another worksheet elicits "0"
  197. Struggling with use of global Boolean
  198. extact files from oracle into excel
  199. summary of dates
  200. summary of dates
  201. Plotting a graph using HH:MM:SS values
  202. Creating a user adjustable countdown timer
  203. email only a range in excel in lotus notes
  204. question on script
  205. Publish Excel Page to the Web ? ?
  206. multiple math functions
  207. Last cell with entry
  208. Copy, Find, Paste Macro - Urgent
  209. Forumula showing not results
  210. I want 1st page of my printout to have pg 3 not 1 and incr from there
  211. Simple macro loop problem...
  212. Detecting Click Event of Dynamically created controls
  213. Passing arrays to functions?
  214. Grouping Dates in a report
  215. Excel Trouble in displaying large data
  216. #DIV/0! Problem With Formula
  217. Help with FIND function
  218. HELP..Select Entire Row and Use FIND function
  219. Excel VBA macro - how to close the excel application
  220. appending data in workbook
  221. saving conditional formatting
  222. Macro to consolidate records from several excel files into 1 excel file
  223. DOS command script to copy records from multiple excel files into 1 excel file.
  224. Object Error
  225. Not sure if Excel is best solution for my problem
  226. Displaying Unknown symbols in Excel (Square symbols)
  227. Event when i change active sheet
  228. macro help required fairly urgently please :)
  229. String manipulation using VBA
  230. Using MATCH()?
  231. Excel.EXE crashes
  232. change labels to formulas
  233. Macro to Import and format Data from ACCESS
  234. Digital signature in a protected sheet
  235. How To Analyze These Tables?
  236. Find, Select, Copy And Paste Macro - Urgent
  237. nested if's?
  238. yearly plan
  239. excel shortcuts keys
  240. "Application-defined or object-defined error" in Excel 2003
  241. Opening a database of a program
  242. Help: how to lock cells after fulfilling a condition data
  243. Taking Parameters from Excel to MS Query
  244. Issues moving Excel VBA from VISTA to XP
  245. To create a new dialog box
  246. What is the code to prompt user before action is taken
  247. What is the code to prompt user before action is taken
  248. *.txt to excel
  249. Convert MSSQL TSQL to a Formula
  250. Need to Populate Cells in a Row based on a Date Range