PDA

View Full Version : Microsoft Excel

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