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