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. Editing in Word and saving in Notepad while controlling everything in Excel
  2. Unstable event code
  3. Convert workbook code to worksheet code
  4. Auto print last filled page
  5. Sum of column
  6. Effectively using Classes and Property Let/Get; referring to parent or sub class...
  7. Displaying missing values from 2 worksheets in another separate worksheet
  8. Solved: Deleting part of a merged cell
  9. Solved: Calculate Time Left
  10. Solved: Delete all info other than name on left side of cell.
  11. [SLEEPER:] Login to yahoo mail.
  12. Solved: VBA code for checking possible combinations of 4 numeric digits
  13. copy folder WB to a one workbook
  14. Macro to drill into pivot table
  15. Automation error (Error 440)
  16. Solved: Pivot Table
  17. Dynamic Looping Help
  18. Help to disable popup calendar
  19. Filter Problems
  20. Solved: Enabled Button
  21. Excel VBA Coding for xls transformation
  22. Solved: DoubleClick event in a textbox
  23. copying a range from multiple csv files
  24. Solved: how fix it - vlookup in visible range (not invisible)
  25. Share workbook with digital signature
  26. Solved: Checklist compare
  27. Solved: Zero the negatives
  28. Effect of AND and OR operators on Type Long
  29. Append excel table into Access table on weekly or monthly basis
  30. Solved: To reflect latest data updated in a row range
  31. How to generate weekly/monthly reports from daily report using macros
  32. [SLEEPER:] Changing Chart Titles
  33. Deleting empty worksheets in a workbook
  34. Copying a picture from a web page and pasting into Excel
  35. Solved: goal seek w/ value from another workbook
  36. interact with web page
  37. Compare 4 columns & find dissimilar
  38. Search Function Problem
  39. Round off Issues and more...
  40. Search data within the spreadsheet to log
  41. How to create the menu w/o the code as the attached file
  42. Function Help
  43. Solved: Data Validation: Combine Two Cells In Drop Down Only
  44. find with xlprevious not working
  45. Solved: Dissect result
  46. Search Date in Worksheet and Set Format
  47. Solved: 2003 Multibox Color fix
  48. help with vba code please
  49. Help with code
  50. Solved: Help Date's
  51. Solved: Red Font
  52. Copy data
  53. Problem with If...Then...ElseIf Loop
  54. custom format
  55. Solved: Import Web Data with HTML format
  56. timekeeping template
  57. Problem showing images in locked sheet
  58. Count non empty cells
  59. Getting Error when No visible Cells found. What to do?
  60. Macro to look at list in sheet1, if not in sheet2, pull in
  61. How to re-arrange the listcolumns?
  62. Reading Data and creating a table from it
  63. Textbox Userform: Autopopulate textbox from another textbox
  64. Solved: Lookup County
  65. Updating sheet automatically periodically
  66. Copying a range from a different workbook
  67. Height of Prina Area
  68. Drill into a Pivot Table using a Macro
  69. Data Validation code error
  70. How to destroy (de-filter) individual advanced filters in a worksheet?
  71. Macro vlookup with fill down
  72. Linking dynamically allocated row offset to stacked column chart data range variable.
  73. Solved: loop Error
  74. Solved:Looping a section of code
  75. Solved: Basic VBA problem with Format
  76. Solved: VBA to Excel Add-in
  77. Data Validation based on 2criteria
  78. Solved: Look excel range?
  79. Make a report with data taken from cells
  80. Solved: Delete Empty Cells
  81. Solved: Entering Value in Combobox with Dynamic Range
  82. cannot get rid of error message
  83. Why doesn't the xlcelltypelastcell not giving the last cell inside a list?
  84. Move files and ignore file extension?
  85. vlookup with input box to select a new month when run
  86. Set the values for .TextFileFixedColumnWidths in code
  87. Solved: concatenate cells in IF statements
  88. List Ranges with Missing Data in Column
  89. HTML table code
  90. Solved: Range Selection error
  91. Moving to Excel 2010 - worksheets.move compatibility
  92. Macro: Highlight Cell in Col B that DOES NOT exist in Col A
  93. Help Exiting Loop
  94. Combo box in Excel to query MySQL
  95. Unlock Blank Cells in Column G
  96. Advanced Filter Command Buttons
  97. Copying Characters to the Right of a Selected String in a .txt file
  98. Drop Down Validation Double Dependency
  99. How to password protect grouping?
  100. Solved: SUM Formula
  101. Cells that update automatically
  102. VBA Data Analysis Loop Problem
  103. Creating a list of variables
  104. Unhide bug
  105. Solved: Range matrix
  106. Solved: multiple interior.colorindex
  107. Solved: error handling failed
  108. [SOLVED:] Conditional Formatting Help :-)
  109. Solved: Range selection with array of ranges
  110. Solved: Cannot switch to an active excel workbook from word
  111. Code understanding
  112. Create worksheets from a list
  113. Solved: Find
  114. Tricking Sort Logic
  115. Convert UTC to local time with DST
  116. E-mailer from individual e-mail to 1 e-mail
  117. Solved: Setting wb.Name to string for VLOOKUP formula
  118. Solved: searching a word in lower and uppercase
  119. Replace Chart labels with Textboxs
  120. Question about vba programming
  121. how to search for a string in text file
  122. Solved: Shell and Wait Issue
  123. [SOLVED:] Stripping numbers from alphanumeric strings
  124. Solved: Delete Rows
  125. VBA code to hide rows
  126. Solved: Listbox1: Highlight Pre selected Item
  127. Copy Paste File Specified in Cell to Another Folder
  128. Confusing issue with Copying and moving work tabs
  129. Solved: Quick VBA Userform Pivot query
  130. Solved: Copy from one workbook, to another, keeping format.
  131. connetct own help file in excelVBA function addina
  132. Problem with .xlsm file adding code via VBA
  133. Solved: Strange Error in simple VBA macro
  134. userform filtered search
  135. Solved: Sumproduct with HLookup
  136. [SOLVED:] Find text in a cell,copy row and paste into new sheet
  137. How To Copy Paste File Named in Cell to Another Folder Named in Cell?
  138. RGB (R, G, B) to hex function
  139. VBA Code Freezing
  140. Need Help - Macro Not Working Properly
  141. Compare two spreadsheets
  142. Solved: VBA for updating every worksheet in workbook.
  143. [SOLVED:] Problem with more then one each.. for cicle
  144. Solved: Display the first word separated by comma in textbox
  145. Filling in IE form with values from Excel
  146. [SOLVED:] Strange problem when protecting/unprotecting sheets
  147. Solved: copy cells to column without blanks
  148. saving spreadheet to network drive
  149. Converting Matlab Code to Vba
  150. Why the Set temp(0) = Activesheet.Columns(3).insert is not working?
  151. VBA Help
  152. Solved: Workbooks.Open issue in Excel 2010 (Network Drive)
  153. VBA Excel Transpose all files in a folder
  154. Solved: Conditional Format 2 arguments; one of them is only a part of a cell contents
  155. Comparing string differences between two separate column of sheets???
  156. Merge first sheet of multiple excel file
  157. Solved: Userform Option Button Issues
  158. replacing characters in a column which occu at random positions
  159. Publishing Defined Names to single Htm page
  160. Expressing a " in an excel Formula as VBA code
  161. Solved: Filter and VBA
  162. Solved: VLOOKUP Code
  163. Solved: Allow Authorisation On 2 Computers
  164. Solved: Application.Countif - separate workbook
  165. Solved: VBA Copy
  166. save as with auto name
  167. Solved: Speed up an Array Formula in VBA
  168. Solved: UserForms: Passing inputs from one to another
  169. Reading values from a closed excel sheet
  170. Solved: making a list of the datasheet
  171. Sorting Options for Several Data
  172. Compare two spreadsheets-Macro
  173. Debugging Runtime Error '13' Type Mismatch
  174. Solved: MsgBox to list missing .references
  175. on each day, at 6am, the excel file will be opened by itself
  176. Macro Help: Replacement for cut and delete Speed wise
  177. [SLEEPER:] Sorting sheets within a workbook
  178. Solved: rd_filename = Active.Workbook.Name
  179. Find cells within range equal to 70% of sum of total range
  180. Solved: select worksheet and display selected sheet in workbook
  181. Master Filter for Pivot Tables
  182. [SOLVED:] Make VBA code shorter
  183. Problem with VBA script reading from MySql database
  184. [SOLVED:] Working on a not visible Worksheet
  185. String and Combox Question
  186. Solved: Not understanding Custom Icon Macro
  187. Return Types in Excel VBA
  188. Solved: Insert Row after Specific Text
  189. Solved: Runing a macro by clicking on a sheet
  190. Delete and Move a row in excel
  191. Automate Click, Save Close
  192. Make a simple report with VBA
  193. Solved: userform multiselect listbox - select item
  194. mutliselect listbox via looping a range
  195. Extract email out of changing string count
  196. controlling cell entries
  197. Solved: Re-calculating cells with unrecognized functions
  198. Copy text from Word and paste into Excel VBA
  199. Solved: Msgbox interrupts drawing on worksheet
  200. Solved: Separate generated password with dashes
  201. Cannot Insert Column
  202. VBA web queries - error 1004 "The site reports that the address is not valid"
  203. Solved: variable formular depending on number of work sheets
  204. SendKeyys command turns off Numlock
  205. Two Columns (Search and Copy)
  206. Comboboxes filling with for loop
  207. Declaring global Boolean variable?
  208. read/write to textfile
  209. Loop through all visible worksheets in excel
  210. On error resume next
  211. Is it possible to automate results from an access query into Excel?
  212. Using data collected in a module/ macro
  213. Solved: Variable dimension of a matrix
  214. Solved: Copy deleted info
  215. [SLEEPER:] FileDateTime(pathname)
  216. find info in cells,delete cells with no info and paste to printsheet. then repeat
  217. Is it possible to do automation to control another application through vba code?
  218. [SOLVED:] Need help in event
  219. VBA code to import pdf as txt to Excel
  220. Solved: .Find not working between Workbooks
  221. Solved: PRICING GRID
  222. Copy WS to a Named WS values only
  223. [SOLVED:] Auto open file at fixed length of time
  224. Copying File issue
  225. Solved: Problem with ListBox
  226. Swapping Cells
  227. Solved: Problem with declarations and Str function
  228. [SOLVED:] Message Box Reminder
  229. Solved: Problem with cut/paste to last row of sheets
  230. right-click in textbox
  231. [SOLVED:] Start Counting when cell changes
  232. How to pick the random numbers from a set of numbers
  233. draw arrows
  234. Solved: Setting filters from a form
  235. Solved: Creation of Folders and Sub-Folder
  236. Insert picture in sheet + send range via email
  237. Solved: VBA to calculate last month
  238. Solved: Page Break
  239. How to Connect to an API
  240. Solved: Returning TextBox data to msgbox or cell
  241. Solved: copy first sheets from all work books in a file into a collective sheet
  242. [SOLVED:] Get Final URLS?
  243. Solved: Help modifying excel timer
  244. how to create a aktive excel table
  245. getting #N/A as value
  246. oracle connectivity
  247. Solved: Help with Commad bar
  248. Solved: vba to open web page in IE and save it
  249. Disable passwords/unhide sheet
  250. Using Vlookup between text file & spreadsheet