PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 [73] 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174

  1. Simple simulation help
  2. name box extender
  3. Solved: Conditional Formating for weekend
  4. Simplifying code from excel to word
  5. [SLEEPER:] Deleting by columns lastrow
  6. Conditional Formatting
  7. Sleeper: Is UDF called from Wizard ?
  8. Solved: CSV To Sheets In Workbook Using ID Number
  9. Please help! I don't even know where to start.
  10. Solved: Occurance Count
  11. [SOLVED:] Userform ComboBox - Type Mismatch error in code
  12. Loading XML file using VBA
  13. [SOLVED:] Games Behind Formula
  14. returning the reference to a cell, not the value in the cell
  15. how to facilitate multiple users.
  16. Solved: Delete 0 length strings
  17. Find and Compare
  18. Solved: create custom menu w/ hyperlinks to open files
  19. Sheet protection and tabs
  20. Solved: Text File import - recognising values
  21. excel help........
  22. Join and Count
  23. Date plus hours excluding specific time interval
  24. Multi Time sheet production
  25. Excel Pivot Table Failing to Calculate an Average on a Calculated Field
  26. links to closed workbooks
  27. Solved: how to check if a desktop shortcut exists
  28. Solved: VBA summation errors in macro
  29. need vba code to automatically format cell as hyperlink
  30. renaming a file
  31. Macro to find the string before special character from Right
  32. Solved: Delete used rows in worksheet(sounds easy)
  33. microsoft developer map
  34. Turkish character issue in query from SQL server
  35. custom error message box
  36. Excel 2007 Crashes Frequently
  37. Solved: xls to xlsm files.
  38. Solved: seperating folder and filename
  39. Deselecting double clicked item in listbox
  40. Problem with Paste Picture Link
  41. XML and VBA
  42. Solved: Macro for Insertion of Lines between data
  43. [SOLVED:] If Range Is Nothing
  44. Change button focus
  45. Prompting User to Select a Data Range
  46. Solved: Help with Userform
  47. Solved: Arrays
  48. Urgent - Countif as an array formula problem!
  49. Error during compile
  50. Don't exit if there was no button clicked
  51. VBA Sheet Name
  52. Turning off Autofilters & formatting
  53. macro
  54. chart help
  55. Solved: Only run code if staffnumber is equal to xxxxx
  56. I'm trying to create a time sheet with stopwatch
  57. Caculating time between dates and counting if another criteria is met
  58. Find data only specified Range ??
  59. Manage all Hyperlinks in Workbook from new Worksheet
  60. Solved: Get length of string inside parentheses
  61. Find workbook name when macro run in add-in file
  62. Embedding objects Excel 2007
  63. Solved: range value
  64. Solved: automaticaly fill date of write
  65. Solved: Cycle through validation list and spit out value of a specified cell
  66. Solved: Check Group Rows For Non Mathes
  67. I am in way over my head Need help
  68. ref the activecell value in an inactive sheet
  69. Solved: Combining workbooks into one workbook with a part of the a filename
  70. Solved: workaround for using PNG files
  71. Open the Task Pane
  72. Solved: FIND, COPY AND PASTE
  73. Solved: Viewing Hyperlink locations
  74. Sorting quetion
  75. Problem with deleting files
  76. Explain Excel’s Task Bar’s Toolbar Options
  77. Solved: recalculate a function
  78. Weekday Conditional Formatting
  79. Moving data on networked drives
  80. How to check on open event for macro
  81. Problem with RecordSet and "LIKE" Operator
  82. Open a subfolder deeper than the first
  83. Solved: Macro explain.
  84. Solved: Print Preview - Detect
  85. Solved: BeforeClose event not working
  86. Solved: Reading data-range from excel workbook
  87. Obtaning current date time through VBA
  88. Excel VBA Change text colour depending on another cell's content
  89. VBScript and Excel Addins
  90. Making a settable clock in VBA
  91. Redundant code
  92. Sending email with lotus notes using data from excel
  93. Solved: To Copy Cell in other sheets
  94. Matching elements of two character arrays
  95. Solved: VBA macro - conditional column fill
  96. How to add scroll bar in userfrom
  97. Solved: Mapping search
  98. Solved: Sorting Alphanumerics and Extracting numbers from them.
  99. Copy to Last Row
  100. Why would scrolling cause Application.InputBox "Cancel" behavior?
  101. Solved: count of different products
  102. Solved: Spreadsheet Max'd Out
  103. Solved: Macro.
  104. Solved: Temporarily Change BG and Font Color of Active Cell
  105. Solved: #NA Error with VLookup
  106. Insert hyperlink function to active cell
  107. VBA Excel Addin - appearing in Project explorer and not in Extras-Addins list
  108. Solved: Forms on moving values
  109. List of files in a folder and sub folder
  110. Solved: Need a Function or Vlookup to replace Nested If
  111. copy help
  112. Solved: Listbox RowSource from Access
  113. [SLEEPER:] Importing columns from another file into current spreadsheet
  114. Convert days into months
  115. Solved: Automating Scipt
  116. Do Loop help
  117. Generate PDF file
  118. Find a value in a text file and remove the entire line
  119. How to Detect If .csv file Is Open in Win 7
  120. copy column
  121. Solved: That Pesky #REF Error
  122. Solved: hightlight highest time
  123. Solved: Set focus on a control
  124. Solved: highlighting a row in excel if selected
  125. Runtime Error 1004
  126. Solved: Chart formatting with VBA
  127. Expiry Date Validations
  128. Solved: Error 1004 Bad Range definition?
  129. Solved: Select columns to copy
  130. Solved: String into Array
  131. add a # of hours to a time?
  132. Macro to save as filename and sheet name
  133. Solved: Keep form on top while keeping full excel functionality
  134. Solved: Change Password - Multiple Files+Common Password
  135. test file name
  136. Emailing multiple attachments from Excel
  137. Force Save to specific Folder
  138. Creating new tabs
  139. Is this a solution for sumproduct?
  140. How to Change the Axis Numbers Color on a Chart
  141. copying trough lock cells
  142. Loop row deletion code through multiple sheets
  143. Solved: Subfolders
  144. [SOLVED:] Formula to extract Lotus Notes username
  145. Solved: VBA code to copy range to another specific range
  146. Solved: Find the min or Max value in an autofiltered range
  147. Solved: Conditional drop-down lists
  148. view two different sheets in same workbook
  149. How can one unlock a VBA project (and it's modules) using vba
  150. Solved: Update Links window appears, why?
  151. [SOLVED:] Filtering data up to a predetermined cumulative total
  152. Can not get data to change when I format the cells
  153. Solved: put current date in a column if any change in row
  154. Solved: Split string into two columns
  155. [SOLVED:] Using SumIf with a Date Range as the Criteria
  156. VBA Recalculation?
  157. EXCEL VBA HELP SENDMAIL
  158. Problem in displaying a progress bar
  159. Filters not applying in VBA code
  160. Solved: Adding Customers to my project
  161. Solved: Why It doesn't find all hyperlinks?
  162. [SLEEPER:] For..Next Loop with problem
  163. Solved: What type of control do I need?
  164. Solved: Excel 2003 Userform not posting until its closed
  165. Conditional Format based on two column criteria
  166. How to save intermediate values in a VBA code execution?
  167. Clear Cell Value before re-running the VBA
  168. Userform from hidden worksheet
  169. Solved: Save worksheet as new workbook, with macros disabled
  170. Solved: Modifying workbook links
  171. Solved: Help with code to fill in emply code in worksheet
  172. Systematic access of files within directory
  173. Conditional Subtotal Help
  174. scrolling through each entry
  175. Solved: Resources - Download
  176. Finds row count, but only 99% of the time
  177. How to submit a web form without a name?
  178. Drop down on every cell in column
  179. Solved: % problems
  180. Check if a value is in an array
  181. I have a dynamic SUM function problem
  182. Solved: Macro Error
  183. Solved: Variables in String Issue
  184. Tough one
  185. Conditional Formatting in VBA
  186. DoEvents ActiveWorkbook.RefreshAll Run second part of Macro Once Complete
  187. Solved: Duplicate Data Concatenating
  188. Solved: Cell value from cell in different sheet
  189. Browse Folder
  190. Moving cells from 1 line to another
  191. Data Validation Question
  192. OLEObjects.Add and Worksheet_Change event
  193. Extracting a specific part from a string
  194. Monthly repayments
  195. Solved: Personal.xls not loading - usual solutions not working
  196. Calendar Control 12.0 enquiry
  197. Solved: vb "Upper"
  198. Change Font Within Formula
  199. Solved: Some sheets no hyperlinks.
  200. Unable to Assign a Macro to a "Shape" in Excel 2007
  201. Solved: Set Range depending on font colour
  202. cells value
  203. delete value
  204. Dynamicalyy set range depending on the populated cells
  205. Writing the character " into Cell
  206. Solved: Difference between two times - Macro
  207. Excel screen stretching
  208. Hyperlink Error - Need Help!
  209. Solved: Shell command to open pdf file in Acrobat 8.0
  210. get data from other excel files dynamically
  211. [SOLVED:] Delete Rows based on Multiple Cell Criteria
  212. Solved: Select Specific Cell Range
  213. Formula Error Message in Excel 2007 Sheet
  214. Solved: Sort - convert code to work on 2003 ?
  215. Solved: Open 1st workbook from userform in workbook 2
  216. Solved: Macro To Loop through a column in the workbook
  217. Solved: Populate listbox based on folder contents
  218. Need help with a Formula Creation
  219. Solved: LOOKUP, But Exact match
  220. [SLEEPER:] Excel data Connections to pull data
  221. simple loop macro
  222. Change Application width of active worksheet focus
  223. Password Protected drives
  224. Solved: Using msoFileDialogFilePicker
  225. Solved: MIN formula
  226. Solved: Prevent save as .xlsx
  227. Solved: How to answer the msg box automatically?
  228. Solved: date conversion macro
  229. Solved: BeforeClose not firing on hidden personal.xls
  230. Manipulating Shapes in VBA
  231. Solved: Delete select columns
  232. time format display
  233. Wrap text in text box
  234. Creating conditional lists using VBA
  235. Solved: VBA Subscript out of range errors on sheet code
  236. How do i Configure the I.E within Excel
  237. VBA - GOTO named range
  238. Solved: Sorting using range names
  239. Solved: wildcard use with xlSheetVeryHidden ?
  240. VBA Create Charts
  241. Solved: Using Variables in Named Ranges
  242. MAX and MIM problem in Arrays
  243. Run-Time Error 3704 with ADO & SQL
  244. Solved: Custom Array function for calculating variance
  245. Excel file close
  246. Solved: How do I export my xls correctly?
  247. Solved: OPEN FILE
  248. Micro for TAT
  249. Cascading combo boxes from SQL Server
  250. Activating mouse scroll wheel in listbox