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

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