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. Solved: For Next Loop not completing
  2. [SOLVED] Building Tables from List
  3. Solved: Using Vlookup On UserForm
  4. sorted data
  5. Solved: Formula results are different then Pivot Table
  6. Solved: VBA Assigning Variable / Runtime Error 1004
  7. Solved: Supressing '#N/A' in WorksheetFunction.VLookup
  8. tab colour
  9. Combinations
  10. ANNIVERSARY DATE
  11. Solved: Sales forecast
  12. Check box control on a worksheet
  13. Solved: cell.adress question
  14. Solved: number format 0.00 €/m²
  15. Macro to do logic based on other column
  16. Solved: .FormulaR1C1 = "=" & Formula_A
  17. Solved: copy paste doesn't work
  18. Solved: TextBox: Entering Date in specific format
  19. Excel VBA. Calculating worktime with different overtimes
  20. Solved: Optionbutton deselection erases range value
  21. Solved: Copy/Paste All Cells on a Non-active worksheet
  22. Need a reference on where I can hire a local vba Excel expert to work on a project
  23. how to remove some range of cell only,
  24. [SOLVED] Further variation of Index/Match
  25. Toolbare with option
  26. Solved: Concatenate If in an Array
  27. Custome objects and Collections Classes. Help Please!!!
  28. Selecting a range of sheets using crit in my Criteria
  29. Solved: Printing Problem
  30. Macro help - "Force Use Macros" plus "Auto Close"
  31. Strange formula - now sure how it works
  32. Automatic Cut/Paste to new sheet at every month end
  33. Solved: Trouble Storing Worksheet in a Variable
  34. Solved: Rounding in units of 0.5
  35. Error handling: #REF!
  36. do not display hide worksheets in data validation list
  37. Solved: Array Formula not recognizing Imported Data as a Number
  38. Solved: Validation data - excluded from list
  39. Solved: VBA - Value Copy Multiple Criteria
  40. Noob with a (probably) simple one
  41. Find problem
  42. [SOLVED] Question on Hpyerlink
  43. cells colour
  44. Consolidating multiple sheets onto one "parent" report sheet.
  45. Adding a chart
  46. Excel Chart Object Name
  47. Solved: display msgbox once
  48. Edit objects
  49. Delete rows when the code gets deleted.
  50. checking string in IF Loop
  51. VBA for combo box
  52. Is it possible to write vba code to create a conditional format on cells?
  53. "FindNext" function
  54. Solved: Using Excel To Send Emails Through Lotus Notes
  55. Retrieving Data from another Worksheet
  56. Solved: Login Prompt
  57. Solved: Positioning UserForms
  58. Solved: TRIM in VBA
  59. Solved: Is it Vlookup or Sum Product ?
  60. Excel + Access Help
  61. Solved: need dynamic range
  62. option button macro
  63. Solved: Need to loop thru a folder of workbooks and extract customer addresses
  64. comparing the 2 excel
  65. Solved: Enter the next consecutive number
  66. Listbox active workbooks and copy data
  67. using Excel function TRIM rather than VBA function TRIM
  68. Clear contents in the last populated cell
  69. email different sheets to different people - code needs changing
  70. Is it possible to transfer data from ms access to excel using vba code?
  71. Solved: Conditional Formatting only when value is present
  72. Solved: Import a Silhouette & select X & Y coordinates then do a vlookup Based on the value
  73. Solved: Loop through controls and add data from cells
  74. Searching from a list in Excel, extract Phone#'s from contact's in outlook 2003
  75. Solved: Make sure numbers are increasing
  76. Navigating Through a Recordset (Adding a Record Counter)
  77. Create 1 Public Sub for 5 textboxes
  78. Solved: POP UP Message when a criteria is met
  79. Menu tree
  80. Formatting a column into "text"
  81. data model in excel
  82. Solved: Excel, append & retrieve numbers in a txt file with next number in increments one
  83. Using iMacros in a loop with input from Excel
  84. Solved: how do i get the the name of the user who opened the file?
  85. Using vba to open website
  86. Solved: Locate values from List
  87. Extract rows to new worksheet and save as new workbook
  88. Excel Problem
  89. Solved: Selection Rows CountA?
  90. Solved: Code not updating all worksheets
  91. SSN Format
  92. Update code in 220 objects
  93. SUM IF in vba and result in message box
  94. Solved: Problem with copy/paste "Formats"
  95. Using Yes No Message Box
  96. Excel 64bit issue with Winsock UDP connection
  97. Automatic Macro execution
  98. Insert Hyperlink from External Source to a Protected Sheet
  99. VBA Chart fill area
  100. Excel 2003 VBA coding and "pop up button" help
  101. Excel 2003 VBA coding tweak
  102. Read external data from dynamic text range, then calculate stats
  103. Solved: Two listboxes on same userform problem
  104. File (path to a folder) not found
  105. creating a data base using Excel & VBA
  106. Print workbook - disable
  107. How do I close an instance of Quickbooks in VBA?
  108. Sum Values in defined target
  109. Solved: need a magic formula to ..
  110. Write data to sheet 2 if sheet 1 is full
  111. "Window" menu item
  112. VBA Help needed total newbie
  113. DOM: Searching only the tags embedded within one particular div tag
  114. Macro help required if possible
  115. Excel keeps switching between 'ready' and 'chart updating'
  116. Solved: Clear Red Interior if Text is Red
  117. excel addin problem
  118. count the no. of A
  119. VBA Copy & Paste
  120. Excel 2007/2010 - Can I have workbook specific disabling of row inserting?
  121. System Error: &H8001010D (-2147417843) An outgoing call cannot be executed...
  122. VBA code below
  123. Filter Sheet With text on cell
  124. VBA array difficulty
  125. Is it possible to use vba to automate a count on recurring data?
  126. Solved: Input Box Validation please help
  127. Solved: Find maximum value in a column
  128. Excel stopwatch needed
  129. max value of another textbox
  130. Open web Page and clink on a link within the page
  131. Set Cell Value As Variable?
  132. How to turn any URL input into file name
  133. pervent only one sheet from deletion
  134. Sumif
  135. Creating charts using VBA: problem with intervals
  136. Report from excel database ??
  137. Ado DB connection in Excel
  138. Solved: Create new folder with name and date
  139. Solved: VBComponents - how to retrieve "Sub" or "Function" exactly
  140. Need help with default save script from 2010 to 2003
  141. Return control after application.run
  142. Solved: Split cell contents into multiple rows
  143. Solved: Selecting a Rows with Data
  144. using conditional formatting
  145. Solved: Mortgage loan spreadsheet problem
  146. Finding special charecters in excel
  147. formula for logical condition
  148. Solved: Code prevents formulas working!
  149. Solved: Merge Workbooks
  150. Sending Excel Cell Data via E-Mail
  151. Solved: Why does code need On Error Resume Next?
  152. SaveAs Command to Overwrites a Excel File
  153. Detecting a cell change
  154. Data Input Form Workbook
  155. How to select option in pop-up list????
  156. excel VBA and post for ASP.NET
  157. Solved: display multiple labels as $0.00
  158. Solved: use input box chara to create new woorksheet name
  159. Run-time error '13' on comparing arrays help needed
  160. Is it possible to upgrade Excel and perform File Remediation using vba?
  161. clear contents formula
  162. Solved: Ignore Countif If Cell Contains a Value
  163. Solved: Disable all saving
  164. Is that possible to excute code by using Keboards "CTRl+Eneter"
  165. Highlight The Selected.
  166. VBA code-Signature code failure
  167. Cut and paste the challenge
  168. Error using Find function
  169. Solved: Insert row above next empty cell within a column
  170. Solved: Question About copy Selection
  171. Basic question about Application.enableevents
  172. highlight the cell with "peter"
  173. Solved: Excel - Change font color if invoice number is out of order.
  174. Solved: disable protected sheet message
  175. Problem switching between Excel and Word
  176. Input Mask
  177. UDF to calculate average according to condition, ignoring blanks
  178. Solved: Specific cell selection
  179. Compile Error
  180. Update only the latest data from Excel to Access table
  181. Extract data from PDF
  182. VBA Select Case
  183. Help with clear contents
  184. Is there a formula or statement that works out percentage rates in Excel?
  185. Solved: Search for text in IE
  186. Last row of the worksheet
  187. [SOLVED] How to print from sheet active to the another sheet
  188. Loop the code
  189. Worksheet Delete
  190. Transpose single column array
  191. Solved: Stop CommandButton moving or rename button
  192. Solved:
  193. Request for review
  194. Solved: Select Row problem
  195. Help defining and setting variables
  196. Permutations
  197. Solved: Decrease qty thru msgbox
  198. Loop Help
  199. VBA to export 2 worksheets at a time
  200. For loop trouble
  201. Printing Copies with VBA
  202. Solved: Only copy selected sheets
  203. VBA code to run on specified time
  204. Solved: Nested IFs
  205. Solved: Directory Path
  206. VBA match, copy , paste and append
  207. Solved: need to contain clearing of row within a range
  208. Solved: Spinbutton and date textbox
  209. Mortgage spreadsheet concept problem
  210. Action when result of formula changed
  211. Solved: Help with loop please
  212. Solved: Columns to Rows keeping data integrity
  213. Solved: userform label format
  214. Solved: Macro to go to first worksheet in any workbook
  215. Solved: Delete after first space
  216. Copy Data to the Serial Number Row
  217. Solved: Simple Formatting
  218. Solved: spinbutton on date textbox
  219. Inserting an image based on the option choosen
  220. Disabling multiple textboxes
  221. Label Calculation
  222. Solved: .text to .value
  223. [SOLVED] Finding text on ie that's next to what you search
  224. Timed VBA Mail code
  225. Solved: Set the Data / Group and Outline / settings..
  226. Cannot get the protection code to work with the rest
  227. Excel workbook "access denied"
  228. Delete the repeated code
  229. Office 2003 Combobox_Enter
  230. Solved: Disable Form Control Button/Code
  231. Solved: The Art of Conditional Formatting!
  232. Solved: Text to columns (With only the first bit of text)
  233. Solved: Create and Edit a Scheduled Task from Excel
  234. Solved: Check the clipboard for Data before paste?
  235. Comparing values from Different worksheets
  236. Need to preventt xlsm file from being converted to xls
  237. Dynamic chart-Modify series formula from vba
  238. Multi sheet macros.
  239. Solved: calculate difference between 2 excel files
  240. Solved: VLOOKUP multiple criteria
  241. Business Days
  242. Modify code to also remove cell borders
  243. Disable Fn Alt and Ctrl Keys
  244. vba password recovery
  245. Copy and Paste between Instances of Excel
  246. Change Column Content
  247. How to populate array with collection?
  248. Excel Macro to delete rows if cell matches List of Values
  249. [SOLVED] find all combinations (no repeats)
  250. Excel 2007 VBA SOAP Web Services Integration