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