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

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