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

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