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